delete a digit in a field

[damcloodt]

Hello,

I want to delete the third digit for all records in a column, is there a query that I can use in design view to do this?

for instance "ab 123" should become "ab123"

Thanks a lot for all your help!

 

[DCrake]

if you actually need to delete it see other post use the following
in an update query

UPDATE YourTableName SET [YourFieldName] = Replace([YourFieldName]," ","");

 

[gemma-the-husky]

dc's method will delete any spaces anywhere

if you want to specifically delete the third character then you need to select the first two chars, and the 4th char to the end

so

mystring = left(mystring,2) & mid(mystring,4)

 

[damcloodt]

dc's method will delete any spaces anywhere

if you want to specifically delete the third character then you need to select the first two chars, and the 4th char to the end

so

mystring = left(mystring,2) & mid(mystring,4)

thanks it worked!!