I need to replace/remove quotes from text...

K

Kelvin

I'm trying to use this in a query, but I can't figure out how to remove the
quotes around text ie "Nashville" need to be Nashville.
Company_Name: Replace([CompanyName]," ","")

I'm using Access 2003

Thanks

Kelvin
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I screwed up 0
Append Crosstab Query to Existing Table 0
Wrapping and Anchors 0
Need help modifying code 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Removing Line Numbers 4
Macro to select and delete levels of a document 2
Remove Quotes from Text Strings 7

Top