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 PR
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,,,,