By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,300 Members | 1,795 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,300 IT Pros & Developers. It's quick & easy.

Selecting sub-reports by date criteria

P: n/a
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).
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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]![YourDateControlName]

--
Reggie

----------
"Rene" <tr******@hotmail.com> wrote in message
news:a0*************************@posting.google.co m...
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).

Nov 13 '05 #2

P: n/a
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******@hotmail.com (Rene) wrote in message news:<a0*************************@posting.google.c om>...
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).

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.