Adding two fields from a crosstab query in a report

[Guest]

I am trying to add field1 and field2 together into field3. Field1 and field2
come from a crosstab query where I used the formatnumber and nz functions.

When I use the following expression for field3 I get bad results as if it is
adding text together...

field3 =(field1 + field2)

For example, where field1 = 12 and field2 = 2, the result I get for field3
is 122. I want to get 14.

Thanks for your help!

 

[Duane Hookom]

What is the "formatnumber" function?
Try:
field3 =(Val(field1) + Val(field2))