Need to replace text in a description field of Access 2007
In the description field of our database I need to find and replace I'm with I am. When I try this using the find and replace it doesn't find anything. So I tried making an update query with I am as the update to and I'm as the criteria. It finds o records. There are plenty of records with "I'm" so how do I change it?
The reason I need this ASAP is because the "I'm" code messes up our uploads of the database to PetFinder.