SUM in TextBox doesn't work out... Why? (1 Viewer)

[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

 

[Pat Hartman]

=Sum([ItemPrice])
Should work. Make sure that the control is not named ItemPrice. The control name cannot be the same as the name of a bound field unless the control is bound to that field.

 

[brunces]

Pat Hartman,

Hum, gonna check it out, pal.

Thank you.

Bruno