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

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

 

[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

 

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

 

[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

 

[Dun]

Ups, sorry. Yeap, missunderstood the question.