Thank you all,
I really appreciate your help.
I created an update query and used the left and len function to get rid of space and Color string.
But to make this query more generalized in case if there are different strings after space like "Red Signal" or "Red Color" in the same column on...
HI,
I have a field named Colors in a table A and The same field Colors in Table B. But in table A, I have "Red Color", "Blue Color" and "Green Color" and in table B only "Red", "Green" and "Blue". Now I need to connect table A to Table B on Colors and thus need to remove " Color" from table A...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.