View Full Version : Form SubTotal


stm8ter
02-01-2002, 05:29 PM
I have a form with a subform. In the sub form there are calculations to arrive at extended price.
=[Quantity]*[Quote]
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]*[Quote]
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
02-01-2002, 05:36 PM
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
02-02-2002, 06:30 AM
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]*[Quote]
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
02-02-2002, 06:56 AM
You can't Sum the calculated control, repeat the calculation i.e.=Sum([field1]*[Field2])

stm8ter
02-02-2002, 07:35 AM
Thank You
=Sum([Quantity]*[Quote])
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.