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

  • Thread starter Thread starter Gezza77
  • Start date Start date
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
 
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
 
Back
Top