Problem Summing a Calculated Field in a Report

[TheSearcher]

I have a report that has four fields: Item, Qty, Price and TotalPrice for each line in the detail section. Total Price is calculated by multiplying Qty x Price. The text box name that holds the Total Price for each line is txt_TotalPrice. I want to have a Grand Total in the report footer. I placed a text box in the footer with the following expression: =sum([txt_TotalPrice]). When I run the report Access prompts me for the parameter value of txt_TotalPrice. I've been trying to solve this for quite a while now - but I'm totally baffled. Any help will be greatly appreciated.

TS

 

[vbaInet]

=Sum(Qty x Price)

 

[TheSearcher]

I tried that but it didn't work. It turns out that I need to bracket each field:
=Sum([Qty]*[Price])
Thanks so much for your help!!

 

[vbaInet]

It was only a matter of using "*" instead of "x". The square brackets weren't needed in this case.