Multiple Query with same input

  • Thread starter Thread starter JeffH
  • Start date Start date
J

JeffH

I have created several queries that I input a date range
or a common job number. I'm tired of input the same
information several times. How is it possible it input a
date range once and have several queries work of that
input.

Thanks...
 
Set up a form with 2 unbound fields FromDate and ToDate.
In you query's criteria use
Between [Forms]![formname]![FromDate] and
[Forms]![formname]![ToDate]

Jim
 
Jeff,

Make a simple form (call it FrmDateRange for the sake of the example) with
two unbound text boxes (call them txtDateFm and txtDateTo) formatted as
Date.
In each query's design view, go to the date criteria and enter
=Forms!FrmDateRange!txtDateFm, and
Click to expand...
<=Forms!FrmDateRange!txtDateTo
As long as your form is open, the queries will read the parameters from
there, without you having to retype for each one.

HTH,
Nikos
 
Thanks..
-----Original Message-----
Set up a form with 2 unbound fields FromDate and ToDate.
In you query's criteria use
Between [Forms]![formname]![FromDate] and
[Forms]![formname]![ToDate]

Jim
-----Original Message-----
I have created several queries that I input a date range
or a common job number. I'm tired of input the same
information several times. How is it possible it input a
date range once and have several queries work of that
input.

Thanks...
.
Click to expand...
.
Click to expand...
 
Back
Top