Need to remove # (pound sign) from table field

[johngordon]

I need to remove the # (pound sign) from all of the records (9000+) in a table field. I have tried using Find & Replace, with no success.

Does anyone have any other ideas on how to do this?

Thanks,

John

 

[earthandfire]

You could use an Update query, the precise syntax would depend where in the field the # is.

Hope this helps.

 

[PHV]

Depending of your version of access you may try this update query:
UPDATE yourTable
SET yourField=Replace([yourField], '#', '')
WHERE yourField Like '*[#]*'

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886