Universal parameters

[Roncc]

Is there a way to establish parameters so that they can be used in several different queries without having to be entered the information into each query. I volunteer for a local food bank and am kind of their IT guy. I have created an Access database that we use to keep track of our clients, name, date of birth, number in household, and City they live in. When grants have to be written I am often asked to create a report that details how many households we have provided service to based on the city where the households reside within a specific date range (i.e. 7/1/2024 to 12/31/2024). I have created "buttons' with code that initiate the reports based on the cities with a query to select for each city but, I have to repeatedly enter the date range for each query. Is there any way to create a "universal" date range parameter that will allow me to just enter the date range one time and have each query refer to that parameter when the query is run?



Thanks in advance.

Roncc

[pbaldy]

Most of us use a form to gather user input for reports. I'd add two textboxes to your form for the dates. Your criteria then looks like this:

Between [Forms]![frmReportCriteria]![txtFmDate] And [Forms]![frmReportCriteria]![txtToDate]

[Roncc]

That did the trick, thanks so much.

Ron

[pbaldy]

Happy to help!

[Welshgasman]

I would use TempVars, and probably populated from a form.