Subreport criteria

  • Thread starter Thread starter Tina
  • Start date Start date
T

Tina

I have a form where I enter client information and dates for various
meetings.
I have a report with 3 sub-reports so I can get the total number for
each field for a quarterly report. One client may have an orientation
date and a screened date but not an admissions date, one may have a
screened date only, etc.
The data right now is 9 screened but only 3 admissions.

Main report contains the date range.
Sub report 1 = Total # of Orientations during date range (record
source is Orientation Query)
Sub report 2 = Total # of Admissions during date range (record source
is Admissions Query)
Sub report 3 = Total # Screened during date range (record source is
Screened Query)

How do I make this happen and is it possible to get a date prompt only
once for the report date range to apply to all the subreports.

Thanks.
Tina
 
The simplest way to enter the dates once only is to create a little form
with unbound text boxes for StartDate and EndDate. Instead of a parameter in
your query, refer to the text boxes, e.g.:
Between [Forms]![MyForm]![StartDate] And [Forms]![MyForm]![EndDate]

The queries for the subreports can do the same thing.
 
Back
Top