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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filtering subreports on main report 0
Can't create a report from my query in Access 1
Gouping In Sub Reports Leaving Windowed Headings 2
Sub report message 18
Hide Sub Report(s) when records are null 6
Reports, Sub-reports running sum and no data 2
Page break between sub reports of a sub report 1
Totals are doubled when report is a sub report 3

Back
Top