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),div ision_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