|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#21
February 22nd, 2010, 11:49 PM
posted to microsoft.public.access.queries
|
|||
|
|||
how can I concatenate fields that contain numbers?
David W. Fenton wrote:
It seems we are definitely in violent agreement. shall we settle this with pistols at dawn? :-) 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 -- Microsoft MVP - ASP/ASP.NET - 2004-2007 Please reply to the newsgroup. This email account is my spam trap so I don't check it very often. If you must reply off-line, then remove the "NO SPAM" 
|
|
#22
February 23rd, 2010, 12:36 AM
posted to microsoft.public.access.queries
|
|||
|
|||
|
how can I concatenate fields that contain numbers?
On Mon, 22 Feb 2010 13:10:01 -0800, Lorina
wrote: 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. -- John W. Vinson [MVP]
|
|
#23
February 23rd, 2010, 10:30 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
how can I concatenate fields that contain numbers?
"Bob Barrows" wrote in
: David W. Fenton wrote: It seems we are definitely in violent agreement. shall we settle this with pistols at dawn? :-) 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 ....in other words, YOU DISAGREE! -- David W. Fenton http://www.dfenton.com/ usenet at dfenton dot com http://www.dfenton.com/DFA/
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
