Infinite Pages in Report

[Quentin Stringham]

Hi everyone

I am having the strangest problem in Access. I have created a cross-tab
report that groups on several fields. It uses two queries and a bunch of
DLookups to populate the fields.

The report is structured like so:
Task Number Header
(Main heading information)
|
--Date Header
(Date headings for crosstab)
|
-- Employee Header
(Actual detail of report, includes employee names
and time charged on each date from DLookups)
|
--Detail
(Empty; No Data)
|
--Date Footer
(Sums of data from employee header)
Task Number Footer
(Contains a subquery that summarizes all pages of data for Task Number)

Okay, the weird thing is that on some reports (but only some!), Access
generates an infinite number of pages. The reports that end up with infinite
pages have data from the Employee Header that spills onto a second page. Any
report that can fit all the data for a task number onto a single page
generates perfectly.

Bizarre, eh? Any ideas? Has anyone run into this problem before?

 

[Quentin Stringham]

Never mind. The local office genius solved the problem. FYI, if you have a
summary in a footer that spans multiple pages, you will get an infinite
number of pages. Apparently, Access is confused when a footer takes several
pages to print...