I am doing one project using vb6.0 with ms-access. my question is How to create ( monthly wise and year wise report in one query) based on below query. [ rec.Open "select Sales_Person_ID,Employee_Name,sum(Total_value),division_name,segment_name from segment_trans GROUP BY Sales_Person_ID ,Employee_Name,division_name,segment_name order by division_name,segment_name", con, adOpenKeyset, adLockOptimistic ] because i am using separate query for month wise query and year wise query i got very confusing result. Please help me Thank you sathik srbatcha_29@yahoo.com