Page totals in my reports

[allong]

I need to put a total on each page in my access report. I tried to sum the field I need the total from but I get an #error. I tried dsum but I got a total from the entire table. I need page totals. Help if you can.

 

[Trendsetter]

I have not tried this but it should work.
Put an unbound textbox in the Page Footer and in the Control Source of the textbox enter:
=Count(*)

Frank J Hill
FHS Services Ltd.
frank@fhsservices.co.uk

 

[CosmoKramer]

allong,

Check out this thread:

thread703-326104

Let me know if this helps....

 

[danvlas]

Another way to skin this cat:

thread703-542582

HTH



Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html