Hi all,
I am having a problem with summing a text box value in an Access 2010 report page header.
The text box I am summing is a calculated text box named [Total Pricing] and has the following expression and is working fine:

=[Cost Packet Quantity]*[Unit Pricing]
I am trying to sum these [Total Pricing] boxes in the report header with another text box and the expression and I am receiving an error:
=Sum([Total Pricing])
I keep receiving #Error in the field when I run the report.
The format is set to currency.
Running sum is set to overall.

Thanks for your help.