My fields won't add toegther in Access (VALUE:([VALUE1]+[VALUE2])

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

Guest

Hi I have a query in Access where two fields will just not add together!
Has anyone had this happen to them??

Can anyone help!?
 
If one of the fields is Null (blank), the answer will be Null.
Use Nz() to indicate to use zero for null, i.e.:
Value3: Nz([Value1],0) + Nz([Value2],0)

If that doesn't work, tell us about the data type of these fields. If they
are Number they should add, but if Text you may need to typecast them.
Details in:
Calculated fields misinterpreted
at:
http://allenbrowne.com/ser-45.html
 
I hope you're using & and not +. :-) It might be problem with field
data types or you're just missing some operator in the field. What's
the error message?
 
Hi -
If you are attempting to add, you sure would want to use '+' and not '&".
Example:

value1 = 3
value2 = 4
? nz(value1,0) & nz(value2,0)
34
? nz(value1,0) + nz(value2,0)
7

Bob
 
Back
Top