data type

E

Ernie

I have a text field with both letters & numbers. I know how to eliminate
the letters, leaving only the numbers. This string of numbers has a group
of leading zeros. My question is: After eliminating the letters, how can I
create a Make Table query to convert this field into a number field?
 
R

Rick Brandt

Ernie said:
I have a text field with both letters & numbers. I know how to
eliminate the letters, leaving only the numbers. This string of
numbers has a group of leading zeros. My question is: After
eliminating the letters, how can I create a Make Table query to
convert this field into a number field?
Click to expand...

Wrap that result in a function that converts it to a number...

Val(), CInt(), CLng(), etc..
 
Top