Report Prints endless pages

[zjzastava]

I have a report that has 8 columns and 17 rows. The last columns and row are for displaying the totals of the other 7 columns and 16 rows. This is all in the details section of the report. The user uses a form to enter a date range that populates the report. When you click the print icon it prints out the report. Page 1 is perfect and it should stop printing because the report is only 1 page long. Instead it prints additional pages until you cancel the job. In addition ONE of the total text boxes in the row doubles with every new page it prints.

If anyone knows how to make this work properly that would be great.

Thank You
Zac Z

 

[dhookom]

Check the record source to see how many records are returned. Are there any subreports that you haven't mentioned?

Duane
Hook'D on Access
MS Access MVP

 

[zjzastava]

The record source for the report is set to the table name. This is the only table that data is being pulled from. I am not sure what to check when you ask me to see how many records are being returned. Each text box is displaying 1 number from a query. Except there is 1 row and 1 column of text boxes that is adding up totals. There are no subreports.

If I was unclear or you need more info just let me know.

Thank You
Zac Z

 

[dhookom]

Why do you think the page should only be 1 page long? Do you think it should only print 1 record or just enough records to fill a page?

How many records are in the table?

How does "Each text box is displaying 1 number from a query" when the report's record source is a table?

Are all of the pages the same?



Duane
Hook'D on Access
MS Access MVP

 

[zjzastava]

The report is only 1 page long because that is all that is needed. It has 8 columns and 17 rows. The last columns and row are for displaying the totals of the other 7 columns and 16 rows. The 7 columns have the heading of the day of the week while the rows are labeled with hours of the day. Then all have a total.

The table has 11,502 records in it.

I have the record source for the report set to the table name and the control source for each text box set to Dlookup function that calls the specific query for the particular day and time.

All the pages being printed have only 1 variation. On every additional page being printed only 1 of the total text boxes is being doubled with every new page. All the other data is the same.

 

[dhookom]

I think from your other thread, you are working way to hard to get your data displayed on your report. If you choose to use DLookup() to display your data on the report, then your report should probably not have a record source.

However, DLookup() is probably the most inefficient and difficult method for placing data in a report.

Duane
Hook'D on Access
MS Access MVP