i am doing one project using (vb6.0 + ms-access + crystal report 8.5)

SELECT division_name, sum(Total_value) FROM segment_trans WHERE date between (Param1) And (Param2) GROUP BY division_name;

this is my ms-access query (param1 and param2 thease two parameter value.)

in crystal report i pass this two parameter date  values through run time.

i want vb6.0 coding for this above problem

please give me a good solution.

Thanks

sathik



Software/Hardware used:
vb6.0 and crystal report 8.5 with ms-access2003