How do I use Access 97 module(or macro or anything) to check if one field 

in a table has ', then automatically update them to ".  I had some help 

from here but I can't work out the code to do it exactly. I don't have any 

forms, just table and queries in this Access 97 database.  If it will be 

easier to use a form, I can create one.  I tried:

replace

mid

But not really sure how to use them.  Any help will be great.  Thanks.

Z

> How do I use Access 97 module(or macro or anything) to check if one 

field 

> in a table has ', then automatically update them to ".



Look at my answer to the question "Unable update table with single quot 

record ( ' ) "



Leif