Search results

Okay, forget it. I've found the solution. Thank you again guys

Okay guys, another problem appeared when I'm importing from my excel. Maybe because of the NOT LIKE syntax. Can you guys help me again?:banghead:

Worked like charm! Thank you very2 much!!!

Screenshot is the result of my code. POE Item is the original name of the data, the ERPCODE is the changed name. So what I want to do here is, any POE Item name start with E-* and S-* change to W-*, any name start with NYB* should not be touched or remove, leave the ERPCODE as POE Item. The code...

I will try each of the solution tomorrow and be updating here.

Okay, lets start this over. I have 3 set of data. 1. E1234 2. S1234 3. NYB123 What i want to change is data number 1 & 2, change only the first letter from E & S to W. What i dont want to change is data number 3. So the end result should be: 1. E1234 -> W1234 2. S1234 -> W1234 3. NYB123...

Okay, lets say i have 3 data from my DB. 1. E1234 2. S1234 3. NYB123 My code can change all first letters to W, but i dont want to change the NYB123 to WYB123, i want that data untouched. i managed to change the first letter to W, so i think the code perfectly working. So, the end result...

SELECT "W" & Mid([ITEMNO],2,24) AS ERPCODE This code work perfectly well to change all the first character from DB to W. The problem is, I have one more data that I don't want to change the first character. Tried stackoverflow's solution but can't get it work (Cannot give link due to new comer)...

Hello guys, newbie here. I'm Shafiq from Malaysia, just started exploring Access for the past months. Hope you all can guide me to become a professional. Thank you!