Two queries sharing a parameter?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

I have two subreports embedded in a main report. Each subreport has its own underlying unique query. The report shows the correct data when run. Each query needs to be narrowed according to a date range

Currently, the following parameter criteria is being used successfully in both queries

Between [Enter the period start date: dd/mm/yyyy] And [Enter the period end date: dd/mm/yyyy

The problem is that the user has to enter a starting and ending date twice. Is there anyway that the user can enter the dates only once, but BOTH queries are narrowed by the date range

Any help is appreciated

Cheers
Jody
 
A more user friendly method of supplying the dates would also solve your
problem.
Create a small unbound form (frmDates) with 2 textboxes (txtFrom and txtTo)
and 2 command buttons -'Continue' (opens the report) and 'Exit' (closes the
form).
User enters the dates in the 2 textboxes and click 'Continue'.
For the date criteria in the 2 queries use:
Between Forms!frmDates!txtFrom and Forms!frmDates!txtTo


--

Alphonse Giambrone
Email: a-giam at customdatasolutions dot us


Jody said:
Hi,

I have two subreports embedded in a main report. Each subreport has its
Click to expand...
own underlying unique query. The report shows the correct data when run.
Each query needs to be narrowed according to a date range.
Currently, the following parameter criteria is being used successfully in both queries:

Between [Enter the period start date: dd/mm/yyyy] And [Enter the period end date: dd/mm/yyyy]

The problem is that the user has to enter a starting and ending date
Click to expand...
twice. Is there anyway that the user can enter the dates only once, but
BOTH queries are narrowed by the date range?
 
Back
Top