Adding two fields from a crosstab query in a report

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!
 
Back
Top