Good morning,

What is the best approach for finding and replacing parts of strings in an Access database? For instance:

The database field could contain the following string:
Q4 = "Married" OR Q4 = "Separated" AND Q76 = "No" OR Q76 = "Does not apply"

I need to be able to replace both instances of "Q76" with say "Q77"

How complicated is this? I'm not even sure where to begin!

I am using VB 6.0, Access 2002, and connect as an ADO recordset.

Thanks for any suggestions!
Mary