sub-report?

  • Thread starter Thread starter Lisa
  • Start date Start date
L

Lisa

Is there a way in Access 97 to generate a 'sub-report'?
The report provides several fields of info for user
specified time frame, and also want separate report with
just one field that was included in first report without
having to re-run report and re-enter times. Is this
possible?
 
Create a Form with Controls into which the user enters (or selects) the
appropriate date/time information, and run each report from a separate
DoCmd.OpenReport in VBA code in the Click event of a Command Button, taking
the user-entered dates to create the WhereCondition argument. When using
this approach, you should not have Parameters on the Report Query... the
WhereCondition will take care of limiting the data.

Larry Linson
Microsoft Access MVP
 
Back
Top