Report - Date Range

[spaz9876]

I'm hoping this is an easy question.
I have a report that I want someone to be able to enter a date range for "Completion Date" to show all jobs within that range.
Right now the report goes to a query that lists all jobs that have a completion date. How can I do like a pop up so that it will automatically query the report to show the specific date range?

[OBP]

You can do this using either the Query Criteria Row or for a bit more control and better formatting you can use a form to input 2 dates.
To use the Criteria Row enter this in the Criteria field for the Completion Date -
Between [Start Date] and [End Date]
The query will then prompt you for the 2 inputs, but the user will have to enter the "/" between the days, months and Years, but if they get the input format wrong for a date the query won't work.
If you use a form with 2 fields you can set the fields Format to Date and have an Input Mask to enter the "/" symbols.
To use the Forms fields in the Query Criteria row you have to use the the following
between [forms]![FormName]![Start Date] and [forms]![FormName]![End Date]

where FormName is the name of your form and the 2 fields are Start Date and End Date