Find and replace using VBA?

[rnickels]

Hello,
Is it possible to do a find and replace using VBA or SQL.
I would like to be able to replace fields (the attendee's name) in my attendance_table.

Each attendee's name appears multiple times in the attendance_table, so I am thinking that a loop would be the answer but I do not how to do a loop.

For example:

If a person changes their name (by marriage for example), I would like to be able to find all instances where the previous name appears in the attendance table and replace it with their new married name.

I hope this is possible.

Thank you for your time.

 

[odin1701]

An Update query should do this with no trouble.

 

[pbaldy]

One way would be an update query:

UPDATE TableName
SET FieldName = "Jones"
WHERE FieldName = "Smith"

 

[odin1701]

Yup.

But what if you have two people with the same name? How are you going to differentiate between them?

 

[pbaldy]

You can't. I don't like the design; I'd have an attendees table, and only be storing an ID in the attendance table. That said, the SQL given is what the OP asked for.

 

[odin1701]

Yeah I just asked the question to get the OP to recognize an issue with the design