Form SubTotal

[stm8ter]

I have a form with a subform. In the sub form there are calculations to arrive at extended price.
=[Quantity]*

This is working fine. However I can not get to the next step. At the Bottom of the form I want to see the SubTotal
=Sum[Quantity]*

Reading other topic lines it appears that I may have to subtotal in the subform and then call that from the main form. I am not gettin this for some reason.
Any suggestions for my next step?

 

[Jack Cowley]

Take a peek at this...

http://support.microsoft.com/support/kb/articles/Q119/1/34.asp?LN=EN-US&SD=gn&FR=0&qry=q119134&rnk=1&src=DHCS_MSPSS_gn_SRCH&SPR=ACC2000

 

[stm8ter]

Thanks I have been there before however I did go back and try again. I have also gone through Northwind. I am to a point where I can't see the forest for the trees.

Sub Form
Text Box name ExtendedPrice
Control =[Quantity]*

OK so Far

SubForm Footer
Text Box name SubTotal
Control =Sum([ExtendedPrice])
Can Not Review if this is working in design view

Form
Text Box name Sub Total
Control =[Forms]![PO Subtable subform]![SubTotal]

Data View #Name?

Revise Control =[PO Subtable subform].[Form]![SubTotal]

Data View #Error

I am sure it is something simple I am just missing

 

[Rich]

You can't Sum the calculated control, repeat the calculation i.e.=Sum([field1]*[Field2])

 

[stm8ter]

Thank You
=Sum([Quantity]*

)
This is now working.

I am still confused on where that little bit of info was on the MS help sheet, but at least it is now workin.