Adding two fields from a crosstab query in a report



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!

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question