How do you do a range of dates? 1

[cell0042]

If a user wants to be able to at anytime pull information between two dates without you having to keep making a new query. How do you set up a query that will let a user enter two dates?

 

[RobPotts]

Hi,

In the date field you want to run the query on add the following

Between [Start Date] and [End Date]

This will then bring up a text box when the query is run and the user can fill the dates in as wanted.

Hope this helps
Rob!