mato01
asked on
Replace ; with , with Access Update Query
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.
From Original
Texas; Florida; or Michigan with
To New
Texas, Florida, or Michigan.
I need to update the Description field in an Access Table.
From Original
Texas; Florida; or Michigan with
To New
Texas, Florida, or Michigan.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
"The problem is that it deletes the whole field."
What was your query's sql?
What was your query's sql?
ASKER
Perfect. Thanks
Sincerely,
Ed