Convert Tex to Number

  • Thread starter Thread starter JOHN SMITH
  • Start date Start date
J

JOHN SMITH

Hi

I have a column call it WO (Text Field).

the data on it looks like this:

4545-1
2323-500
11985-1

I would like to pass this values into two columns WOPRE (Doble) and WOSUF
(Integer)

WOPRE WOSUF
4545 1
2323 500
11985 1


Any ideas?

Thank you All

Bre-x
 
JOHN SMITH said:
I have a column call it WO (Text Field).

the data on it looks like this:

4545-1
2323-500
11985-1

I would like to pass this values into two columns WOPRE (Doble) and WOSUF
(Integer)

WOPRE WOSUF
4545 1
2323 500
11985 1

Bre-x
Click to expand...
In a query select the field WO. Use two calculated fields:
WOPRE: CDbl(Left([WO],InStr([WO],"-")-1))
WOSUF: CLng(Mid([WO],InStr([WO],"-")+1))

Roxie Aho
roxiea at usinternet.com
 
Back
Top