Sum of two fields in a query

[Sym]

I am trying to add together 2 fields in a query but it keeps returning the wrong value, for example my first field(IRNzCount) value is 10 and the second field(U1NzCount) value is 2. I should get 12 as the result but instead i get 102 which is the two numbers just being put beside each other.

The expression im using is
[IRNzCount]+[U1NzCount], i have tried it with brackets, I have tried using the formatnumber function on both the fields and the expression but i get the same result.

If i use [IRNzCount]-[U1NzCount] i get the right result of 8 or if i multiply them and i get 20. So why doesnt the addition work? is there another way i should be adding these together?

fyi

these fields have had the Nz function used on them in a previous query to fill in null values

thanks

 

[D.E.N.N.I.S.]

Is your form field TEXT instead of NUMBER?

 

[D.E.N.N.I.S.]

Or perhaps try this?

Val([IRNzCount])+Val([U1NzCount])

 

[Sym]

Val([IRNzCount])+Val([U1NzCount])

That worked

thanks