Passing Dates to Queries

[Chip]

Hey everyone,

I did a little search for this in the groups but didnt find anything.
So if I'm rehashing an old topic, I'm sorry.

I have montly reports (dont we all) that I need to produce for my
organization. I can get the queries to show me the data that I'm
trying to find. However, somethings are unrelated as far the Dbase is
concerned. For example, I have a database that accounts for CE
Classes that we are responsible for. Some classes are Cancelled,
other ran and some have unkonwn dispositions. Each class is also
affiliated with a Trainign Facility, or a County. So my table roughly
looks like this

ID
Class#
Training Facility
County
Date
Outcome

Obviously there are more topics. So I can get a queiry to show me, CE
Classes by County, or Classes that were Cx. I can also get it to show
me that information for a particular Training Facility and by date.
Etc.

But, what I cant seem to get, is how do I get things onto my reports.
For example, my Monthly Report may say, show me Classes that were
Cancelled And Ran, but also a breakdown of classes by County, or By
Trainign Facility. So I'm working with multiple queries and need them
all incoroporated in the same Report.

Ultimately though, how to do I pass the same set of dates to each of
the qurieis that make up my report. I may only want to see, 5/1/08
thru 5/30/08 for all these items.

Chip

 

[KARL DEWEY]

Use an unbound form with text boxes. Refer to the text boxes like this --
[Forms]![YourFormName]![TextBoxName]
Enter date in the text boxes then rune reports.