multiple pages

D

Dan @BCBS

I created a report from a query.
I added a text field to count a certain value.
This is the Control Source =Sum(Abs([ReferredBy]="Care Coordination South"))
It counts correctly but my problem is that I get many pages.
How can I stop the multiple pages and have just one page.

Thank you
 
G

Golfinray

By multiple pages, do you mean it is spreading your data out over too many
pages? If so, go into the main section of the report and change forcenewpage
to after section or before section, whichever one that works best. If that is
not what you mean, post back.
 
D

Duane Hookom

If I understand correctly, you should change your report's record source
query to a totals query that calculates your value. Otherwise, you may be
able to simply set the report's detail section to Visible: No.
 
Top