Access 2003
Company transports bricks. A delivery note is printed for each load. No of
bricks per load available to report. Could have 20 to 30 loads against
original order. Quantity per load is no problem until the last delivery
which may have a balance less than the bricks per load.
E.g. 25,000 bricks ordered. Bricks per load 9,500. Balance last load, 6,000.
Can I predict number of pages to print, total all quantities on all
preceding pages and deduct that from the order quantity to enter a balance
for last shipment?
Played with the OnPrint and OnFormat events to no avail.
Is there any way to calculate total pages of report before
previewing/printing, this might help.
pj