Error Using Text box from aggregate function

[wrweaver]

I created an aggregate query to feed a report that I want of all products i use in a year and a total price for all products. I used a sum function of the line totals in a text box to display the total expenses for all products, but it keeps giving me an #Error message. I attached the pictures of my query and the report.

 

[boblarson]

You need to rename the control that is bound to the field LineTotal. Currently it is named the same as the field and when you have an expression on a report that refers to a field, the control that is bound to that field can NOT have the same name.

Rename the control to txtLineTotal and then go back and change your expression back to using LineTotal (as I assume you probably have not disabled Name Auto Correct, which I would do).

 

[wrweaver]

Still gives me the #Error