Report footer moves about

[AKMonkeyboy]

I am trying to print a report that will have from 1 to 12 records. I am using a "client header" for client info. In the detail area I am showing billing info by invoice number. This area will have 1 to 12 records. I am using client footer (not page footer) to summarize billing information by client. The problem I am encountering has to do with the footer. If I size the footer to line up with the forms I have, and I have one record, it works great. However, if another detail record comes in, it pushes the footer down and my forms no longer line up. I fix it to line up with two detail records, and it doesn't line up for someone with one detail record (or 3, or 6, or 12...). How can I tell Access to "always print footer starting at "inch 9" of the paper? Thanks in advance.

 

[VogonPoet]

I don't think you can.

I think there is a workaround though. You can put the detail records in a subreport and set the subreport to be x inches tall. Create a query that creates the totals and link the subreport to the summary information on the appropriate field(s). You then place the summary information at 9" in the detail section.

I hope this helps. Let me know if I need to do a better job explaining this.

Michael