how can I concatenate fields that contain numbers?

[Bob Barrows]

No! I don't want this classic agreement dispute to end!

I've often said it's no fun at all to argue with people with whom
you really truly disagree -- it's only fun when you're 90% in
agreement.

Well, I can't argue with that ... <BEG>

 

[John W. Vinson]

I have a spreadsheet that has UPC # but each numer is in a cell. In our ERP
system it's listed as one number. I want to vailidate that it's entered
correctly in ERP system. I pulled in the spreadsheet and concatenated the
cells (with help from Ken on this message board). In a new query I linked
the query above to the part master field in our ERP system. I want to
subtract them and, if entered problerly, the difference = 0. That part
works. Now I want to have it only return results when they are <> 0 (only
those that are incorrectly entered into the ERP system). When I put in <>0
in the criteria it tells me there is a data mismatch!

So... are you subtracting the UPC Numbers? or are you subtracting the number
of rows? If you're concatenating multiple number fields, the result is a Text
field, NOT A NUMBER, and you will get an error.

Please post the SQL view of the query you're using now.

 

[David W. Fenton]

Well, I can't argue with that ... <BEG>

....in other words, YOU DISAGREE!