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 

Replace( CompanyName, """", "" )


Hoping it may help,
Vanderghast, Access MVP


"Kelvin" <someone@domain.com> wrote in message 
news:uNxdTTGLIHA.2176@TK2MSFTNGP06.phx.gbl...
> 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
>