troubleshooting Question

Report Footer printing on page 2 when using columns in detail

Avatar of valencehealth
valencehealth asked on
Microsoft Access
9 Comments1 Solution349 ViewsLast Modified:
I have a report that I use columns in the detail so that there are 2 columns on the page going up to down and then left to right.  The detail is also set to Keep together because it contains several lines.  I also have a report footer on the report.  The report is working fine for the most part except for one the detail goes into the second column but doesn't use the entire second column.  When this happens the report footer gets printed on the next page, however if the bottom detail in the first row appeared on top of the second row there would be plenty of room for everything to be one page.  This is what it looks like:

Page 1:
----------------------------
      Approval Report
App1       App6
App2       App7
App3
App3
App4
App5
---------------------------

Page 2:
---------------------------
Report Footer
Total of Approvals: $100



---------------------------

I would really like for the report footer to print directly under App7 (it is the same width as the details).  But if that can't be done then I would at least like the report to move App5 to the top of the second column so that there is room for the footer at the bottom of the page.  Thanks.

Ben
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 9 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 9 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros