Deleting a single character in a text field

  • Thread starter Thread starter ma1000
  • Start date Start date
M

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.
 
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.
Click to expand...
Create a update query, use

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

as new value.


mfG
--> stefan <--
 
Back
Top