I'm trying to replace all ; (semi comma) within a field with , (comma) with a update query. The problem is that it deletes the whole field.
I need to update the Description field in an Access Table.
Texas; Florida; or Michigan with
Texas, Florida, or Michigan.