update query that removes extra letters

[alinapotter]

I need to create an update query that removes the extra letters xxx and ggg from the field in my table. I am having a trouble finding a right function that goes to "update to" field. I need help. I am taking an access class and got stuck on this step of my assignment.

[June7]

You want to remove 3 x's and 3 g's that are in sequence?

Try:

Replace(Replace([fieldname],"xxx",""),"ggg",""))

[alinapotter]

Yes, there are 3 x's and g's in the begining or middle of the words. I just need to remove them so those words look normal. For example, Nevada and not xxxNevada or Texas and not Tegggxas.

[June7]

Did you try suggestion? Make copy of the table for testing before running on the real data because can't undo.

No situations like Hagggard where the 2 g's are correct?

[alinapotter]

It worked! Thank you.