Using Query to Find and Replace

[curban6325]

I have data downloaded to me on a weekly basis which I have to clean up
for my report.

In table view in Access I run a find and replace on a field to clean up
text to the left of my "(". For example:

Find What: *( Example: John Doe (PTDI)
Replace With: ( Example: (PTDI)

I use this to remove data to the left of the "("

I need to be able to do this in a query to save me time but I am not
having any success. I would appreciate any assistance I can receive
with this.

Thank-you!

 

[Tom Ellison]

Dear Curban:

It is not necessary to change the data in the table to do this, but that's
one alternative. Another alternative is to make the change in a query on
which the report is based. Which is best depends on a survey of all the
purposes for which you have this data. If they all require or at least
tolerate this change, then by all means, make the change.

Update TableName
SET ColumnName = "(PTDI)"
WHERE ColumnName = "John Doe (PTDI)"

This would make the specific change I understand you have requested. I'm
assuming the word "Example" is not part of that with which you're dealing.

Tom Ellison