Calculated Field inside a Subform??

[merv805]

I have a purchase order database that has a subform with many products.

I have already placed a "sub-total" control that is

=[Quantity]*[Price]

The problem is that I can't seem to figure out how to use that control "sub-total" and calculate a grand-total within the subform.

Subform
Table: Product
Fields: Quantity, Price
TextBox(Sub-total)with Control source: =[Quantity]*[Price]

Is there an alternative method of doing this or is there a way to place that "Grand-Total" on my main form???

Can anyone help me with this simple question?? Thanks in advance!

 

[Kleiny]

Is this subform in Datasheet view or Form view? If it is in Datasheet view make it Form view and set the fields up to look like it is in Datasheet view. The reason for this is that you can use your form footer of the subform to do the totalling but only in Form view.

Hope that helps.

 

[merv805]

I tried the form view. Unfortunately my main concern is that since I'm using a subform, inside the report I only could get to view it as a datasheet.

Can you only do calculated controls within the footer of the form...??

this is what my form looks like

quantity description price Subtotal
= quan*price

I need another heading or place I can use that Calculated field Subtotal and create a Grand Total control.

Hopefully this makes sense....Thanks so much