Auto-Sizing Report Sections

[Pianoman178]

Hey all,

I am having a problem with the size of various sections in a Microsoft Access invoice report.

-The report header has our business information.

-The page header has SOLD TO and SHIP TO information, such as Date, Shipped By, Terms, Date, etc...

-The detail section has the information of the parts that were sold. This includes PartID, Description, Quantity, Price, etc...There could be up to 10 different parts per page on each invoice.

Below the detail section, in the Page Footer is the Subtotal, Shipping Cost, and Final Total section.

I would like to have the total information display after the last Part in the invoice, instead of having it in the same spot at the bottom of the page reguardless of how many Parts there are.


Let me know if you need clarification anything!

Thanks!

 

[lameid]

You could put the totals in your report total. Then they would just be at the end of the report.

You should add an invoice footer to your report and put the totals in there so you can run it for more than one invoice at a time.

 

[Pianoman178]

I assumed you meant:

"You could put the totals in your report footer"

Well, I tried it and it worked! I was previously trying to make a variable-length page footer, which I guess is not possible.

Thanks for the speedy response!