REmove Text from field using the Make Table Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am building a Make Table Query that takes data from an outside source. I need to remove the decimal point in one field when I run the make table query. For example: I need to take 256.0 and make it read 2560 or 256.00 to 25600 or 256 would be left alone. It runs in my mind that I can use a substr function but not sure

Thanks for any help
Linda - IA
 
You can use the "replace" function to replace "." with ""

-----Original Message-----
I am building a Make Table Query that takes data from an
Click to expand...
outside source. I need to remove the decimal point in one
field when I run the make table query. For example: I
need to take 256.0 and make it read 2560 or 256.00 to
25600 or 256 would be left alone. It runs in my mind that
I can use a substr function but not sure.
 
Back
Top