Limiting data based on entry date

[HeatherD25]

Hi,

I have a form where a user can select a begin date and end date from a drop
down menu. I have a report that I would like to open after they select the
date. The report is based on 3 different queries -- basically the 1st query
has to run, then the 2nd query has to run, and then the 3rd query has to run
in order to get to the final data that I want to display on my report. The
date limitation is on the first query where I would like to limit the data
set. How do I program this in Access to limit the data on the first query,
and then run query 2 & 3, and then open the report?

Thanks!!
Heather

 

[Stefan Hoffmann]

hi Heather,

How do I program this in Access to limit the data on the first query,
and then run query 2 & 3, and then open the report?

If the date field is on a bound form, then use

Forms![yourDateSelectionForm].Form![yourDateField]

as criteria in your query. Otherwise use

Forms![yourDateSelectionForm].Form.[yourDateCombo].Value

as criteria.

The form must stay open, while running your query.


mfG
--> stefan <--

 

[HeatherD25]

Do I put that as the "Between... And" statement in the query criteria line?
Would I create a macro to run each of the queries and then open the report?

hi Heather,

How do I program this in Access to limit the data on the first query,
and then run query 2 & 3, and then open the report?

If the date field is on a bound form, then use

Forms![yourDateSelectionForm].Form![yourDateField]

as criteria in your query. Otherwise use

Forms![yourDateSelectionForm].Form.[yourDateCombo].Value

as criteria.

The form must stay open, while running your query.


mfG
--> stefan <--