Returning too many pages

J

jbgarrett1

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?
 
J

Jerry Whittle

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.
 
J

jbgarrett1

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.
 
J

jbgarrett1

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 :)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top