Go4Expert

Go4Expert (http://www.go4expert.com/)
-   Visual Basic ( VB ) (http://www.go4expert.com/forums/visual-basic/)
-   -   year and moth wise report with one query in vb6.0 (http://www.go4expert.com/forums/year-moth-wise-report-query-vb60-t21517/)

srbatcha 25Mar2010 11:26

year and moth wise report with one query in vb6.0
 
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

sathik
srbatcha_29@yahoo.com


All times are GMT +5.5. The time now is 14:56.