Limiting a Report to a date range (1 Viewer)

[Chris B]

I am getting ALL the records from the table the report is based on. How do I restrict it to a certain date range?

 

[Jack Cowley]

Create a query and in the Criteria line of the Date column use the Between And syntax to find the dates you want. Search help for query criteria and Between And as well...

HTH,
Jack

 

[Chris B]

Thanks, I created the query, now how do I incorporate it into the report?

 

[Jack Cowley]

Create your report and base it on the query. Use the Report Wizard as it will lead you through the process....

Jack