Calculation Problems

[Miller84]

I have a field in a subform called LineTotal which is calculated by multiplying (price1*quantity1)+(price2*quantity2). This works fine and LineTotal displays the correct answer.

However I have tried to make a Grand total of the LineTotal using the sumfunction in the subform footer =Sum(LinePrice) Then in the main form referencing the footers calculation to get the total. But it says #ERROR.

Can anyone help me out please? I've had this problem before. And I can't find much using the search function.

Thanks in advance!

 

[___]

Place the grand total textbox in the detail section and reference it in a new textbox in the footer section.

 

[ansentry]

Have a look at the attached sample. I think this is what you want.

If you can't work it out then post back.

 

[___]

=[YourSubform]![YourTotalsTextbox]

On your main form

 

[Miller84]

Place the grand total textbox in the detail section and reference it in a new textbox in the footer section.

doing that puts a grandtotal column into the subform which won't work.

I've tried everything you guys have suggested but with no luck. Ansentry thanks for the database file. I can't seem to achieve what you have done. When I put the extprice into the detail section of the subform it appears in the datasheet view calculating the sum correctly but it doesn't show on yours. confused

 

[Miller84]

Ignore that last post. I got it working! Thanks for all your help guys!