Sum expense field for all records of a query

[Ogian]

I would like to sum the expense field for records returned from a query in the report footer. I've got a label and a text box and I've bound the text box to "Expenses".

[pbaldy]

Try this as the control source of a textbox in the report footer

=Sum([Expenses])

[Ogian]

Cool. That works . Thank You. Is there a link to a web page that lists all of the functions available in Access 2010?

[weekend00]

Cool. That works . Thank You. Is there a link to a web page that lists all of the functions available in Access 2010?

Go to the help file, everything are there.