Having successfully used update query routines from Jeff Bridgham and Joe Miller (Thanks guys!) to fill blank cells with a common value, it occurs to me that technique could be used to modify existing cell contents much faster than Find/Replace in Access 2000 - but I can't figure out the syntax. I'd like, for example. to search a field for every occurrence of "$" and replace them all with ".jpg". Grateful as always for any guidance.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search & Replace Queries
- Thread starter JohnieR
- Start date
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question