Multiple Query with same input

[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...

 

[Jim/Chris]

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

 

[Nikos Yannacopoulos]

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

<=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

 

[JeffH]

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...
.

.