Using one date range in four queries

  • Thread starter Stephen Epstein
  • Start date
S

Stephen Epstein

I've developed a set of queries developing the data for a report.
Eventually I'll write a macro to run them in sequence for end users'
convenience. Problem is this: Of the 6 queries used, 4 rely on the same
date range (e.g. transaction date between beginning_date and ending_date).
Is there a simple way to enter the beginning and ending dates one time and
pass the parameters to the selection criteria of all 4 queries so that the
macro won't ask 4 times for the same dates?
TIA
SteveE
 
A

Allen Browne

Create an unbound form with 2 text boxes.

Remove the parameters from your query, and refer to the text boxes on the
form instead. The Criteria row under your date field will look something
like this:

Between [Forms]![MyForm]![beginning_date] And [Forms]![MyForm]![ending_date]

Do the same in the other queries.
BTW, be sure to set the Format property of these text boxes to Short Date or
similar so Access knows they are dates.
 
S

Stephen Epstein

Thanks Allen, I'll give that a shot!
Allen Browne said:
Create an unbound form with 2 text boxes.

Remove the parameters from your query, and refer to the text boxes on the
form instead. The Criteria row under your date field will look something
like this:

Between [Forms]![MyForm]![beginning_date] And [Forms]![MyForm]![ending_date]

Do the same in the other queries.
BTW, be sure to set the Format property of these text boxes to Short Date or
similar so Access knows they are dates.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Stephen Epstein said:
I've developed a set of queries developing the data for a report.
Eventually I'll write a macro to run them in sequence for end users'
convenience. Problem is this: Of the 6 queries used, 4 rely on the same
date range (e.g. transaction date between beginning_date and ending_date).
Is there a simple way to enter the beginning and ending dates one time and
pass the parameters to the selection criteria of all 4 queries so that the
macro won't ask 4 times for the same dates?
Click to expand...
Click to expand...
 
Top