Convert Tex to Number

[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

 

[Guest]

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

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