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