Replace ":" with "0"

  • Thread starter Thread starter RickM
  • Start date Start date
R

RickM

I'm linking Access to an Unix Informix database. Somewhere in the
conversion, i.e. a number appearing in the Informix as 72.60 appears in
Access as 72.6:, it appears to happen totally at random and it appears to
only happen to calculation ending in "0". Since I'm not getting a lot of
help from the Unix folks, I'd like to import the records into a new Access
table and the run a update query or whatever you recommend to replace all
":",s with a "0" , making the new record a number, not a string. i.e. 72.6:
to 72.60. Presently we do this with the find and manual type in the entire
number. Which is becoming an unmanageable waste of time.
Thanks
Rick
 
RickM said:
I'm linking Access to an Unix Informix database. Somewhere in the
conversion, i.e. a number appearing in the Informix as 72.60 appears in
Access as 72.6:, it appears to happen totally at random and it appears to
only happen to calculation ending in "0". Since I'm not getting a lot of
help from the Unix folks, I'd like to import the records into a new Access
table and the run a update query or whatever you recommend to replace all
":",s with a "0" , making the new record a number, not a string. i.e. 72.6:
to 72.60.
Click to expand...


You can use the Replace function to do that. Not sure, but
it would good if you could use a query as the basis of the
import. In that case you could do the replacing on the fly
by using a calculated field something like:

Val(Replace(field, ":", "0"))
 
Back
Top