Calculated field in sub-form

[OLIVIACDLW]

Hi, I'm sure this question has been asked but I can't find the answer I need in the forum.

I have a table 'CUSTOMERS' with a subform 'SALES HISTORY'.

I would like to add calculated fields for '2010 Turnover', '2011 Turnover', '2012 Turnover' etc.

Is it possible to do this from within the form?

 

[binbin]

Hi, I'm sure this question has been asked but I can't find the answer I need in the forum.

I have a table 'CUSTOMERS' with a subform 'SALES HISTORY'.

I would like to add calculated fields for '2010 Turnover', '2011 Turnover', '2012 Turnover' etc.

Is it possible to do this from within the form?

I typed "Calculated Fields" in the search button of the forum and found several threads that might help you.

Anyway, I usually put calculated fields in a query of the subform's record source, then assign a textbox bound to that field. You can also put an unbound textbox in the subform which has the value, for example only, "=[Fields1]*[Fields2]" which multiplies "Field1" with "Field2." You can give that unbound textbox a formula that would give you the turnover results.