Ms Rusty Boyd
Last Activity: Feb 22 '08, 06:27 PM
Joined: Jun 18 '07
Location:
-
I couldn't let it go after you said yours worked, you're right. I put a space after the first astrisk also "* De *" and it did work. Thank you so so much. Rusty... -
UPDATE Cities SET Cities.LName = Replace([Cities]![LName],"De","de")
WHERE (((Cities.LName ) Like "De *"));
Here it is......Leave a comment:
-
I would love to know how to do this in a query, but what you said about adding the space gave me a clue to a low-tech solution. I went to Find & Replace and set the Find to space De space and the de done the same way and it worked. Thank you for setting me on a productive path. If you come up with an Update query solution I would still appreciate knowing how to change some of the value while leaving the rest in tact. Thanks again, Rusty...Leave a comment:
-
I copied and pasted your code and replaced the table and field name but it still said "You are about to replace 0 records."...Leave a comment:
-
I got the reply You are about to update 0 records. Back to the drawing board....Leave a comment:
-
I most definitely will try it. Thank you....Leave a comment:
-
How can I do this with wildcards? I want it to find DE no matter what last name it is included in and convert it to "de" while leaving the rest of the name in tact. Thank you for your interest. Rusty...Leave a comment:
-
I appreciate your assistance, I am new to this environment. Rusty...Leave a comment:
-
Using Update query to change a part of a value?
I am working in MS Access 2003 and I want to use the update query to change part of a value in a field. I have a last name field that contains a lot of records. Someone entered the values De Pedro and De La Rosa etc. and my boss wants them in lower case de Pedro and de la Rosa. I want to update De to de without having to manually change them. I tried criteria Like *De* and update *"de"* but the whole name is replaced with de. How can I...
No activity results to display
Leave a comment: