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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Daily Entry with multiple entries per field 0
Sum If function in textbox 0
How/when do forms & subforms relate? 1
How to create multiple field UNIQUE index? 3
Data entry for a table from a form 2
Display Field 3
Copy record info into new form 0
Drop-down box and loading related data 1

Top