Issues with create a sum for a report?

[ayupchap]

Hi there



So I am creating a simple database for my friends record shop business and trying to create a report that sums up the days sales. I created a text box and put in the formula =sum([Total]) but when I run it it appears with the #error message. Does anyone know why that might be? The field I am trying to sum is called Total. Below is a screenshot of the report design. Thanks for any help you can give

[June7]

Move the textbox to Report header or footer. Aggregate calcs don't work in Page header or footer.

[ayupchap]

Oh excellent, yes this works. Thanks so much!