Returning too many pages

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jbgarrett1 - 05 Jan 2006 20:08 GMT

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?

Reply to this Message

Jerry Whittle - 05 Jan 2006 20:21 GMT

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.

Signature

Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

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

Reply to this Message

jbgarrett1 - 05 Jan 2006 21:18 GMT

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.

Reply to this Message

jbgarrett1 - 06 Jan 2006 19:11 GMT

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

Reply to this Message