Selecting sub-reports by date criteria

[Rene]

I have a master "attendance " report that also has two "attendance "
sub-reports...each collecting data from a different group...and
totaling
those present at the end. I chose sub-reports because of the way they
needed the data displayed. When printing this report, they wanted an
option
to select by date. The sub-reports are linked to the master by this
"date"
field.

How can I print this report without having to enter the "date"
numerous
times (for whatever reason, it's 5 times even though only one query in
each of the 3 reports requires the date field).

[Reggie]

Rene, Set the criteria of your query to use the date you select on your
form. I'm assuming you select a date on your main form then click a button
to print the reports from this main form. Set the criteria in your queries
as follows:

=[Forms]![YourMainForm]![YourDateControl Name]

--
Reggie

----------
"Rene" <tr******@hotma il.com> wrote in message
news:a0******** *************** **@posting.goog le.com...

I have a master "attendance " report that also has two "attendance "
sub-reports...each collecting data from a different group...and
totaling
those present at the end. I chose sub-reports because of the way they
needed the data displayed. When printing this report, they wanted an
option
to select by date. The sub-reports are linked to the master by this
"date"
field.

How can I print this report without having to enter the "date"
numerous
times (for whatever reason, it's 5 times even though only one query in
each of the 3 reports requires the date field).

[Galina]

Hello
Make a form to enter this date. You will need to open this form from
another report, which can be empty and cancelled as soon as it opens
the form. Open your report from OK button of the form, after user
enters a date. Reference all your queries to take date from this form.
Do not link subreports by date to the parent report, rather base them
on queries taking the date from the form.
Hope, it will be of some use.
Galina
tr******@hotmai l.com (Rene) wrote in message news:<a0******* *************** ***@posting.goo gle.com>...

I have a master "attendance " report that also has two "attendance "
sub-reports...each collecting data from a different group...and
totaling
those present at the end. I chose sub-reports because of the way they
needed the data displayed. When printing this report, they wanted an
option
to select by date. The sub-reports are linked to the master by this
"date"
field.

How can I print this report without having to enter the "date"
numerous
times (for whatever reason, it's 5 times even though only one query in
each of the 3 reports requires the date field).