Adding totals in the Page Footer Section

[DanAuber]

I have a report in access with a Detail Section with several lines with values e.g.:

A £500
B £300
C £200

I then want to put a total for these in the Page Footer Section. I have tried =sum(fieldname) - but I just get #Error - can anyone help me please ?

thanks

Dan

 

[dhookom]

You can create another text box in your detail section:
Name: txtRunSum
Control Source: [FieldName]
Running Sum: Over All
Visible: No
Then add a text box to your page footer:
Control Source: =txtRunSum

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]