Subtotals on page for multipage table

[Stu Bulman]

I am duplicating a government form that contains among other things a
18X12 table. The form will be populated from a spreadsheet of about
2,500 rows. Obviously this will result in a continous table of numerous
pages.

Is there a way, perhaps in the footer, to display the total of a given
column ("number of hours") for a given page? I obviously don't won't to
copy and paste over 200 chunks of spreadsheet data onto separate pages.

Regrettably I am not yet conversant with Visual Basic nor Access.

Many thanks,
Stu Bulman

 

[Stu Bulman]

Just a point of clarification. I am do not want to display a "running"
total, but a toltal for a given page itself.

Thanks,
Stu Bulman