removing commas and apostrophes using query

[Kathy MacAthur]

Hi everyone - hope someone can help.

I need to send a comma delimited flat file from an MS Access query (shipping
info) which will be imported into a shipping system. The need the shipping
info without commas and apostrophes. I've have made basic queries in past
but very basic. Is there an easy way to delete or remove something from a
record strictly for export purposes? In other words I don't want to have to
to an update query.

Any suggestions or help would be greatly appreciated.

Thanks,

Kathy

 

[Ken Snell [MVP]]

Sure... create a SELECT query to produce the records that will be exported.
In that query, in place of the field that has the shipping info, put a
calculated field that uses the Replace function to remove commas and
apostrophes:

ModShipInfo: Replace(Replace([ShippingInfo], ",", "", 1, -1, 1), "'", "",
1, -1, 1)