Global Find and Replace for one field in table

[mpetersen]

Hello,
I am working with an adp and have an issue with &'s in one of the fields. I would like to do a global find and replace for ampersands in just this one field within one table to replace the &'s with "and." How do I go about doing this?

Thanks

 

[Brianwarnock]

Use Replace in an update query

Brian