Deleting a single character in a text field

[ma1000]

In one of my tables i have a field that has a text values like '123.23123' i
would like , to delete the full stop. How can i do this. I cant do it in
excel as the number of records that i have is over 200000.

 

[Stefan Hoffmann]

hi,

In one of my tables i have a field that has a text values like '123.23123' i
would like , to delete the full stop. How can i do this. I cant do it in
excel as the number of records that i have is over 200000.

Create a update query, use

Replace([yourField], ".", "")

as new value.


mfG
--> stefan <--