Total Column Calculating Error

[joannakf]

I am trying to total two columns in a query.



Column1: 5
Column2: 2
Total: [column1] + [column 2]

It should come out as 7 but it is coming out at 52 so it is putting those 2 numbers together as if they were text. I change the properties of all of the columns to be numbers.

Help please

[boblarson]

Try this:

Total: Val(Nz([column1],0)) + Val(Nz([column 2],0))

[David04845]

Total : Sum([c1]+[c2])

or click functions and click sum on the drop-down for the column

[joannakf]

Val(Nz([column1],0)) + Val(Nz([column 2],0)) worked!

Thank you!