Deleting Parts of a Table Field

[Guest]

I have a table with fields listing cities and states for different companies.
The city and state are in separate fields.

Whoever created the list, put quotation marks such as this around the fields:

City State

"Memphis Tennessee"
"Baton Rouge Louisiana"
Orange California

I'm going to mail merge the fields, but don't want the quotation marks in
them. The quotation marks are not on all fields as shown above, but I would
like to create some update query or formula that took the quotes out if they
were in the field to have it as the Orange California example looks.

Any suggestions??

 

[Guest]

You can use the replace function to remove all quotation marks from the fields

UPDATE TableName SET TableName.City = Replace([City],"""","")

 

[Guest]

Thank you

You can use the replace function to remove all quotation marks from the fields

UPDATE TableName SET TableName.City = Replace([City],"""","")
--
If I answered your question, please mark it as an answer. That way, it will
stay saved for a longer time, so other can benifit from it.

Good luck

I have a table with fields listing cities and states for different companies.
The city and state are in separate fields.

Whoever created the list, put quotation marks such as this around the fields:

City State

"Memphis Tennessee"
"Baton Rouge Louisiana"
Orange California

I'm going to mail merge the fields, but don't want the quotation marks in
them. The quotation marks are not on all fields as shown above, but I would
like to create some update query or formula that took the quotes out if they
were in the field to have it as the Orange California example looks.

Any suggestions??