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

C

Claris

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!?
 
A

Allen Browne

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
 
D

Dun

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?
 
R

raskew via AccessMonster.com

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
 
Top