problem with summing 2 columns

[kwooten]

I have a crosstab query which uses a NZ function to replace with 0. I have another query where i am doing by totals since it uses multiple queries. My problem is the 2 columns, when I put [column 1] + [column 2] which would be represented by (column 1) being 10 and (column 2) being 5, my outcome is 105. The query just merges the 2 columns... When i do a sum, i get a # that i dont recognize at all.. what am i missing?

[mkallover]

Can you copy/paste the query? You're probably concatenating the fields rather than summing them.