Possible to update ? (1 Viewer)

[kirkm]

Can an single update query fix spelling mistake in e.g. all instances of "Sydney Lipton" change to "Sidney Lipton"

The field is called "AC" and contains other text and "Sydney Lipton" could appear anywhere.

 

[NauticalGent]

In short, yes. A simple Update Query will do...have you tried it?[

 

[kirkm]

LOL no I have not! I'd have to setup some test conditions and fluff around for ages. I'd find it much easier to do it all in VBA.

 

[arnelgp]

it is much faster to proofread and correct
such mistake.
with names, it's hard since there can
be Syney, Sidney, Sidni, Sidhni.
only that person knows and you will
know if you got informed.

 

[June7]

Run UPDATE action sql in VBA.

CurrentDb.Execute "UPDATE tablename SET AC = Replace(AC, 'Sydney Lipton', 'Sidney Lipton')"

Can even run that from Immediate Window.

 

[theDBguy]

LOL no I have not! I'd have to setup some test conditions and fluff around for ages. I'd find it much easier to do it all in VBA.

In most cases, it is faster and simpler to use an action query than VBA [recordsets].

 

[kirkm]

Very nice June, I can see that's a really good solution. Wouldn't have though of db.Execute.