G
Guest
I have a db with customer names that have not been populated the same way in
each field. I would like to be able to look @ the name in the field and in
another field in another column give it an identifier or group id. The logic
statement needs to check the condition and determine what to populate in the
"new column" based on what is in the "existing column"
Example
Existing Column New Column
ABC Co Team #1
XYZ Inc Team #2
abc co Team #1
XYZ Team #2
thanks,
C.Hirsch
each field. I would like to be able to look @ the name in the field and in
another field in another column give it an identifier or group id. The logic
statement needs to check the condition and determine what to populate in the
"new column" based on what is in the "existing column"
Example
Existing Column New Column
ABC Co Team #1
XYZ Inc Team #2
abc co Team #1
XYZ Team #2
thanks,
C.Hirsch