I am new to Access and need a Date Condition on open

[dpwsmw]

I am designing a Report, When I launch the report I would like it to ask for a date and when I enter that date, I would like it to pull only the date that I enter. From a field named transdate.

Can anyone help?

 

[scriverb]

Create a query from your table and prompt for the date in the criteria row for your date column:

Select A.* 
FROM [i][red]yourtablename[/red][/i] as A 
WHERE A.[transdate] = [Enter select date(mm/dd/yyyy): ];

Save and name the above SQL code as a saved query. Use it as the RecordSource for your report rather than the table. When the report is run the query prompts the user for the appropriate date. Then selects the records and runs the report.

Post back if you have any questions.

[COLOR=006633]Bob Scriver[/color]

[COLOR=white 006633]MSU Spartan[/color]