Sum not Concatenate

[abusaif]

Hello all,
I am trying to add values of two fields in a query but Total:sum([value1]+[Value2]) is only concatenating these two fields, where as I want to add them.

 

[abusaif]

Sorry!

I am using access 2010.

Thanks

 

[Alansidman]

Are the fields formatted in your table as Text or Numbers. They may look like numbers but may be formatted in the table as text. This may be the issue.

 

[mahenkj2]

If they are number, try this, it will take care of nulls as well

Total: (Nz([value1],0)+Nz([Value2],0))

No need to use Sum.

 

[Ari]

Hi

try

(val(nz([value1];0))+val(nz([Value2];0)))