How do I sum multiple fields relating to a single field in a form

G

Gezza77

I am trying to set up a form that will totalise multiple fields relating to a
unique identifying field in the same table
 
J

Jeanette Cunningham

Hi,
put an unbound textbox on the form.
Set its datasource to something like = Nz(Me.txtA, 0) + Nz(Me.txtB,0) +
Nz(Me.txtC,0)
where txtA, txtB, txtC are controls for the fields you want to sum.

Jeanette Cunningham
 
Top