Being able to type in a date range and bring up a report for it

[morristk]

I'm doing a database which is going to hold different events throughout the year and I need to be able to bring up any range of dates in a report, and have the events in that date range listed. Any ideas on how I would go about doing this? Please make it idiot proof, as I am not extremely familiar with access to this extent.

Thanks!

Lauren

 

[BusMgr]

Create a parameter query based on the table with start date as one parameter and the end date as the other.

The SQL statement would look something like this -

Select * from tblNAME WHERE tblNAME.EventDate BETWEEN [Input Start Date] AND [Input End Date];

Hope that helps.

BusMgr