Can you put totals in the page footer ? 1

[griet]

I want totals on each page of my report . Is this possible and how do you do it ?

thanks

 

[Databaseguy]

If your field is based on a calculation (Qty * Price named Total, for Example), then in the page footer create an unbound textbox and in tit's control source put the formula =sum([Total]).

If there are no calculations, then your control source would be =sum([qty]*[price])

The help states that sum only works ona calculated field. I've had intermentant luck "fooling" the sum function.

=sum([qty]*1)

Tyrone Lumley
augerinn@gte.net

http://server47.hypermart.net/databaseguy

 

[bethabernathy]

Are you grouping any fields on the report? What are you counting? Beth