...a calculated field in a subform)

Hi All,

Here is the prob I'm facing:
I'm working on a Purchase Order Database and I am trying to create a total of the line items in my subform and have it displayed as a subtotal field on my main form, to which I'll then be able to add such things as Sales Tax & Shipping Cost to get to the Purchase Order's 'Main' Total Amount.

My line item ExtendedTotal field is currently a calculated field: Control Source =[TotalQtyOrdered]*[UnitPrice]

The bottom of Page 859 of the Access 2002 bible (M.R. Irwin and C.N. Prague) - for those of you who can refer to the book - says that I "have to create an additional calculated field on the form I'm using as a subform." However the example in the book was not of a calculated field like mine. Can I still do that? If so, how?

Please help...Muchos gracias!

Dear Friend,

Make sure your subform's Default View attribute is set to Continous Forms. Make the Form Header and Footer viewable. Insert a field in the footer and insert =Sum([FieldName]) as the Control Source.

If you wish to display the Sum in the Main Form, you must set the criteria in the fields where you select items and quantity for a Purchase Order.

Hope this will assist you.

Thanks,
Maha

Maha,

Thank you for the tip. I already did the first part and it's working! :)
Both in 'Continuous Form' and 'Single Form'. The text box I set up in my subform's footer 'Sum of Extended Totals' is calculating the sum of the line items - which is the first step...However, it's not doing my end goal yet, which is displaying it on the main form.

In your reply you said 'If you wish to display the Sum in the Main Form, you must set the criteria in the fields where you select items and quantity for a Purchase Order', can you please tell me what you mean by that? Thanks a lot!

Mita

Mita,

Sorry for delay in reply to you. Cause, I was away to Northern Region of Malaysia. OK then. If you wish, can I have a copy of the MDB so that I can test and advise you. I don't need whole set of you MDB. Just forward me the relevant table and forms.

Thanks,
Maha