Returning too many pages

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

Guest

My report is controlled by a query with 1001 records. I want the report to
count certain instances. Instead of just returning 1 page (the amount of
space the report seems like it should take), it returns 1001 pages.
How can I keep the report for returning a page for every record?
 
You need to limit the number of records at the query. A Totals query will
count, sum, min, max, average, ect., the data.

Please show the SQL for your current query and which fields that you need
grouped and which fields need to be counted or summed up.
 
I'm sorry I made a mistake. It is pulling from a table. The make table query
sql is :
SELECT AllNumbers.CARRIER_DESC, AllNumbers.STATUS, AllNumbers.ITApproved,
AllNumbers.BUApproved, AllNumbers.IVRApproved INTO OverallCount
FROM AllNumbers INNER JOIN Overall_Dialed ON AllNumbers.FW_DIALED =
Overall_Dialed.FW_Dialed;

The report counts Yes/No in ITApproved, BUApproved, and IVRApproved, Each
Carrier_Desc, and then each Status.
 
Sorry I figured it out. I was just being a dork.
I had the count options in the "Detail" section instead of in the report
header.

Thanks for trying to help me :)
 
Back
Top