How to create a parameter query that can be used for multiple reports but the date range needs to be entered only 1 time.

[Galapagos15]

I have an access database that creates several 5 different reports based on a date range and shows different cuts of data. The user would run each of the 5 different reports each month. How can I set up 1 date range parameter query which is used for the first report and then somehow have that parameter saved so they don't have to reenter the same date range when they run the other 4 reports? Thanks in advance!

 

[Joe4]

What I often like to do is create a one-record table to hold my parameters.
Then create a Form bound to this one-record table where you enter the parameters.
Then, link this one-record table to your queries to provide the parameters you need (simply join the table to the query on the parameter field).

 

[Galapagos15]

Thank you very much that worked!

 

[Joe4]

Your welcome! Glad you were able to incorporate that strategy.

One little trick that I used is on the entry form where I enter in the parameters, I change the Properties of the Form to not allow any Record additions or Deletions. That way, as long as people just use the form and don't go into the table directly, I can ensure that there will always be just exactly one record in it, so all my queries will work as expected.

 

[HiTechCoach]

Your welcome! Glad you were able to incorporate that strategy.

One little trick that I used is on the entry form where I enter in the parameters, I change the Properties of the Form to not allow any Record additions or Deletions. That way, as long as people just use the form and don't go into the table directly, I can ensure that there will always be just exactly one record in it, so all my queries will work as expected.

For this to work in a multi-user databases I would assume the table is local table in the front end (split database). Otherwise one user's date range would override anther user's dates.

 

[Joe4]

For this to work in a multi-user databases I would assume the table is local table in the front end (split database). Otherwise one user's date range would override anther user's dates.

Good point. Yes if you have a split database in a multi-user environment, you would want this criteria Table in the front-end database.

 

[Galapagos15]

Thank you for the tips!

 

[HiTechCoach]

Thank you for the tips!

You're welcome.

Glad we could assist.