Crysal 8.5 and VB6, Date wise report, how to do? (Help plz)

hi buddies,

Am using VB6 with CR 8.5, with MS Access. I want to generate a report using date wise, month wise and year wise methods. So, please help me to write code for a report between 2 dates. Example: Starting date & Ending Date. Or, Show report from January 2006 to 2007? How can i select fields from my table to show in reports?

while database name is :DPR
Tables name are: Prod_u1 and Prod_u2
While i have lots of fields those i wanted to show on the report in crystal.

please please please please please help, me,,,,

Hello,

Well this facility is built in Version from 9.0 and above.

But for 8.5 u have to use formula filed , i am explaining u.

Let take an example for montly report.

U take a formula field which only takes the month and year portion in string value , this can be done by using date functioion and convert funtion.

Then make a group of this formula field , now by this way u can summariz the filed for onbe month option and to hid the detial u can suppress that section.

Muhammad Abbas, thanx for ur attention, but i didn't get... :( plz write down the command that i have to use... how to write the code. plz give me a example.
thanx..