Sum of subform in a form

[capsula4]

Hi!

I have a form like this:

MAIN FORM:
[OPERATION ID]
[CLIENT]
{subform}

subform:
[ID PRODUCT]
[QUANTITY]
[UNIT PRICE]
TOTAL: [UNIT PRICE]*[QUANTITY]

So far so good, but now I would like the main form show the sum of "TOTAL"

I tried =Sum([query_name]![TOTAL]) but doesn't work, I see "#Error"

 

[capsula4]

There is a demo database that comes with Microsoft Access, the "northwind database" and I believe this has the functionality you are after, look at the orders form.

Thank you Gizmo!!

Actually isn't exactly the same as I was pretending to do since it calculates the totals in the subform (in the footer of it) and I was trying to do it in the main form... I'm gonna try.

 

[Rich]

You simply add a textbox on the main form and reference the subform textbox that has the summed amount