Removing a Character from a table

[michael1p]

Hello All

I am current creating an Access 2000 database. However I have one table that contains the character / in. It only appears in one column but occurs multiple times and can be in the middle of sections eg 09/10. Is there a good way of just stripping out the one character through a vb module or use of queries.

Regards
Michael

 

[The_Doc_Man]

Look at the Replace function, which allows you to edit fields via an UPDATE query that uses the function on the selected field. Basically you replace the selected character with an empty string.

It is part of the VB6 library, so you would need a reference to that module. Help is available on-line for Replace() under Ac2k3. You would search MSDN for the Replace Function if you wanted to bypass the on-line help.

 

[modest]

Just extending on what doc is saying; replace the slash with a null string:

UPDATE [Table Name] Set [Field Name]=Replace([Field Name],"/","")