RE: multiple duplicate pages in report

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Are you using a subreport? Is the record source query of your report
reasonable?

--
Duane Hookom
Microsoft Access MVP


"DanG" wrote:

I have a report that is based upon a form that filters the results. I choose
the name of an office as well as start date and end date. The report totals
the info properly and gets all the boxes filled out good. HOWEVER, it
creates 1 page per record in the report, so if there are 3 records within the
chosen criteria there ends up being 3 pages that are identical in this report.

Also, I have an "all" selection for the office criteria (it is a dropdown
box). When I choose this the report generates the info correctly, but it
breaks it out per office, it doesnt total the numbers up under "All" heading.

Please help me figure this out. Thanks

.

Relevant Pages

  • RE: multiple duplicate pages in report
    ... "Duane Hookom" wrote: ... The report totals ... creates 1 page per record in the report, so if there are 3 records within the ... chosen criteria there ends up being 3 pages that are identical in this report. ...
    (microsoft.public.access.reports)
  • Re: Print a Report for each record in a table
    ... Check your expression for report totals. ... for totals on the page header and footer to give you totals just for the page. ... Julie had the right idea to give you a report for each record. ...
    (microsoft.public.access.gettingstarted)
  • multiple duplicate pages in report
    ... I have a report that is based upon a form that filters the results. ... The report totals ... chosen criteria there ends up being 3 pages that are identical in this report. ...
    (microsoft.public.access.reports)
  • Re: Null report still needs output
    ... MS Access MVP ... "Shinankoku" wrote in message ... > I have a report for a database I've been working on for 6 months. ... statement in the report totals, ...
    (microsoft.public.access.reports)
  • EMAIL an Access 200 Report
    ... I have created an Access 2000 Report utilizing an Access 2000 Query as input ... from the Report to Excel. ... This however is minor compared to losing the report Totals. ... Access report without losing totals. ...
    (microsoft.public.access.reports)