Updating a part of a field

[Guest]

Hello,

I have an issue here with address data that i need help with. I have
muliple records with Street name misspellings. For Instance:

1111 GORDAN JOHNSON
2222 GORDAN JOHNSON
3333 GORDAN JOHNSON

It's supposed to read "Gordon" with an "O" So.....in the criteria portion
of a query for that Address field, i put "*Gordan*" to locate those faulty
records...and now I want to update them to "Gordon." Is there a way to do
this in Access?

Thank you!

 

[Guest]

First Back up your data

Then use update query with replace

UPDATE TableName SET TableName.[address FieldName]= Replace([address
FieldName],"gordan","Gordon")
WHERE (((TableName.[address FieldName]) Like "*gordan*"))

 

[Guest]

Ofer,

Thank you VERY much - it worked like a charm!!

Thanks again,
SC

First Back up your data

Then use update query with replace

UPDATE TableName SET TableName.[address FieldName]= Replace([address
FieldName],"gordan","Gordon")
WHERE (((TableName.[address FieldName]) Like "*gordan*"))

--
If I answered your question, please mark it as an answer. That way, it will
stay saved for a longer time, so other can benefit from it.

Good luck

Hello,

I have an issue here with address data that i need help with. I have
muliple records with Street name misspellings. For Instance:

1111 GORDAN JOHNSON
2222 GORDAN JOHNSON
3333 GORDAN JOHNSON

It's supposed to read "Gordon" with an "O" So.....in the criteria portion
of a query for that Address field, i put "*Gordan*" to locate those faulty
records...and now I want to update them to "Gordon." Is there a way to do
this in Access?

Thank you!

 

[Guest]

You are very welcome
Good luck

Ofer,

Thank you VERY much - it worked like a charm!!

Thanks again,
SC

First Back up your data

Then use update query with replace

UPDATE TableName SET TableName.[address FieldName]= Replace([address
FieldName],"gordan","Gordon")
WHERE (((TableName.[address FieldName]) Like "*gordan*"))

--
If I answered your question, please mark it as an answer. That way, it will
stay saved for a longer time, so other can benefit from it.

Good luck

Hello,

I have an issue here with address data that i need help with. I have
muliple records with Street name misspellings. For Instance:

1111 GORDAN JOHNSON
2222 GORDAN JOHNSON
3333 GORDAN JOHNSON

It's supposed to read "Gordon" with an "O" So.....in the criteria portion
of a query for that Address field, i put "*Gordan*" to locate those faulty
records...and now I want to update them to "Gordon." Is there a way to do
this in Access?

Thank you!