Pop-up for user to enter date range to search for records

[DianneMD]

I have a query set-up and would like to create a form where a user can enter
a date range to search for records between XX and XX, and get a report with
the data generated. Any suggestions?

 

[What format to use?]

There are many ways to do that.

If you use a query before you go to the report you can have the query
refrence the text boxes in your pop up form I use the build button in the
query to get the address for the pop up form. or you can use something like
this in you query. >Date()-[How many Days Do You Want To Go Back] in this
case when you run the query it will pop up and ask them how many days do you
want to go back. You can do the same for between dates. I always have to
play around with the >< to get it right. The above example works.

 

[WendyWest]

In the Criteria line of your query, type 'between [Enter Start Date] and
[Enter End Date]" then the user can enter the date range they want.

Does that help?