Report Balance Carry Forward and Brought Forward

[chrisfox1975]

Hi

I have a table with logs for vehicle mileages. The report shows, Vehicle Reg, Current Mileage and Date of Use, i have sorted this to show 14 records per page (for our internal log books).

Is there a way for my report to show the previous page closing mileage at record 14 (end of page 1) and carry it forward to the new page which would be record 15 and the carry forward again to the following page?

I suppose a little bit like a bank statement with closing and opening balance.

The table just has three fields VEhicle Reg, Date and Mileage.

Thanks in advance

Chris

 

[arnelgp]

show the report in Print Preview.
view the code on the Format event of the Page Header.
the Unbound textbox is set to Hide Duplicates.
there is also another "fake" textbox beneath it.

 

[chrisfox1975]

Thank you for a quick reply. I’ll have a look when back at my computer.
Thanks

 

[chrisfox1975]

arnelgp, that worked fantastic, thank you. Im just struggling now with the adding end mileage on the report to a box at the bottom, so am just playing around with your solution to find an answer.

Thanks again