Couple of ways of doing this...

Use data grouping with a group footer showing your sub totals and flag start each group on a new page
then use a Summary band as you say
or
You can use the print when clause
If the table is not sorted then your print when can be
RecNo() = RecCount()
or maybe
EOF()

HTH

Will
P.S. Cool surname!
>I want to print a different footer on the last page of a report, can I do this by suppressing the page footer on the last page, & using the summary band, or
>can I detect the last page programmatically, & embed the changes within
>fields?
>
>Hope this makes sense.
>
>Put another way, on the bottom of every page & want to say "running total",
>on the bottom of the last page I want to say "Grand total" (I don't actually want I total of anything here since this will be written on later by a rep).
>
>Many thanks in advance
>
>RC
>Bespoke Software Systems