Re: Can I use a query to find and replace a word in a string?

Karla

In addition to Duane's suggestion, if this is a known, repeating situation,
you could consider creating a table that lists the "As It Comes In" version
and the "As I Want It To Be" version. That way, you wouldn't actually need
to change anything, you could just use a query to link on that field and
generate the "As I Want It To Be" for your forms/reports.

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Karla" <Karla@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:F012F121-F548-4746-A183-B0D1A7FD1D1A@xxxxxxxxxxxxxxxx
It is not a one time update it will be a monthly occurance and the user
will
not be able to access the table only a form, so I was hoping to link the
query to the form for the update. Any thoughts?

"Duane Hookom" wrote:

If this is a one time update, open the table in data*** view and use
the
find and replace in the edit menu.

--
Duane Hookom
MS Access MVP

"Karla" <Karla@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:923D8961-013B-4C09-8222-1AEFBD88E195@xxxxxxxxxxxxxxxx
I have a table with a field that has descriptions and I want to find and
replace only a portion of various records. Is it possible to do this?
For
example if the field said Routed to NAAO TelePartner .....I only want
to
change the TelePartner to TeleSales.





.