Why is the report footer showing up on 2nd page?

[dawnd3]

I asked this before but didn't get it resolved. I have a report in Access 2003, 2 columns, where each group is totaled and then the entire report is totaled. All works well except the report total (in the report footer) wraps to the 2nd page when there is clearly room on the first page. Interestingly this doesn't happen if the report is only 1 column long. I have played with all combinations of property settings and can't figure it out. I even tried adding a fake field to the grouping but it just put the total in after each grouping I already have. Please help!!!

Thank you Tek-tips!!!

Dawn

http://www.calliopeconsulting.net

 

[dawnd3]

just posting to say I found a solution here:

http://msdn2.microsoft.com/en-us/library/aa217618(office.11).aspx

http://www.calliopeconsulting.net