Summing the value of 3 fields in Forms

  • Thread starter Thread starter clueless
  • Start date Start date
C

clueless

I have 3 fields (Value 1, Value 2, and Value 3 in which
I'm trying to get the sum of to show up in a fourth field
(Sum1). Is this possible? I've tried inputting the
following for the "Sum 1" field but nothing shows up.

=Nz(Value 1, 0) + Nz(Value 2, 0) + Nz(Value 3, 0)

Can anyone help?

Thanks
 
clueless said:
I have 3 fields (Value 1, Value 2, and Value 3 in which
I'm trying to get the sum of to show up in a fourth field
(Sum1). Is this possible? I've tried inputting the
following for the "Sum 1" field but nothing shows up.

=Nz(Value 1, 0) + Nz(Value 2, 0) + Nz(Value 3, 0)
Click to expand...

Field names with spaces in them (bad idea) need to be surrounded with
square brackets.

=Nz([Value 1], 0) + Nz([Value 2], 0) + Nz([Value 3], 0)
 
Rick is right on, however, normally it's not necessary to
store the result in a table field--just display it in an
unbound control. When you need it for a query or report,
calculate it on the fly!

KS
 
Back
Top