Access 97 Report similar data on multiple pages

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am generating a report within a certain date range counting the number of
instances for example 14 Domestics in January.
My report is based on a query with the date range. I then add the number of
checkboxes for a cumulative total therein with in the report.

When I go to print preview I get the correct results however I have 14 pages
of the same info... If i have 20 instances of Domestics I get 20 pages and so
on. How can I limit the report to one page?
 
John,

You probably need to group your report and use the group
footer to display your results. Without more information
I am guessing ...... try grouping by the date field in
your record source and group by month. Drag the detail
section of your report to a zero height. This will give
you a set figures such as counts and sums for each month.

Post back with more detail if this sounds like rubbish.

HTH

Terry
 
Back
Top