Crystal Reports

[Ram15]

Hi All, advance thanks for UR help guys.

I am working on crystal reporter. I am basically a starter. My problem is

I want to create Crystal reports in VB with Access as a database.

I have to select certain fields from different database tables and display them in the report. Here the condition is I must select records of that pericular day(sys date basis). ie If I am creating a report today I have to select fields from the records I have added today.

And user will key in the date on which he wants the report from the keyboard(using textboxes).

ie when user clicks a button, a form will appear and ask to enter the date on which he want s the report. Based on the date user enterd, system has to query the database and display the required fields in the report. I appreciate If anyone gives a detailed explanation and code.

Hope U understand my problem. If U need any other information pl let me know. As it is bit urgent, I am thankful to ur earliest reply.

Thank You very much for UR help guys

Cheers and Regards
Ram

[lindawqu]

i think the following code will help you. it's the key part.

CrystalReport1.SelectionFormula = "{Record.Date} = '" & txtDate & "'"