Access 97 Report similar data on multiple pages

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Terry (anonymous_at_discussions.microsoft.com)
Date: 02/14/05 

Date: Sun, 13 Feb 2005 16:55:11 -0800

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
 
>-----Original Message-----
>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?
>.
>

Quantcast