data type

  • Thread starter Thread starter Ernie
  • Start date Start date
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?
 
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..
 
Back
Top