In a Form, can I calculate a Sum on a field that has a calculation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am working in a Form - design view. The format is Tabular. I have set up
a
field that has a simple math multiplication formula of two other fields.
C=A*B I would then like to have a sum of all the C values. In other fields
where there is simple number values, I have no problem obtaining a Sum. Is
it possible to obtain a Sum for a field that has a math formula in the
control source of that field?
 
In the Form "Orders Subform" of the sample database NorthWind, you will find
the example how Microsoft does this. Check the Control in the Form Footer
section of the above Form.
 
Back
Top