Discuss "Help with Updating field" in the Microsoft Access forum.

Hi All,

I have a query where i'm looking for any containing the word "ready", so I have *ready*.

We'll i get results like,


cs-ready
de-ready
lf-ready

I need to update to only change "ready" to "not", so my new results will be,
Field1
cs-not
de-not
lf-not

Thanks!

is there always going to be a hyphen?

__________________
If i helped you, make me famous by clicking the

Hi AOG,

Yes, there will always be a hyphen.

Thanks for the info.

No problem,.. you should put a filter in for "Ready",.. but asides from that you shouldn't have any problems give me a shout if you do

Edit,... basic sample ,..

Thanks Bunches AOG!!!

Got it...was having a bit of an issue with the update part but with the example, got it now!

I also searched info on replace and seems like it works too....did a:

that's the easier way to do it

Replace ([yourfield],"ready","not")