SUM in TextBox doesn't work out... Why?

[brunces]

Friends,

Please, I just created an expression here and it's not working out.

I have a report with a field called ItemPrice. This report is linked to a query.

I created a TextBox to sum all the prices shown in the report.

Here it is...

=Sum([ItemPrice])

It's in the report footer.

It returns me #Error and, sometimes, ?Name.

Please, why? What's wrong?

I also tried this...

=Sum([QueryName].[ItemPrice])

It doesn't work either.

Any ideas?

I thank yor attention.

Hugz.

Bruno

 

[brunces]

Pat Hartman,

Hum, gonna check it out, pal.

Thank you.

Bruno