data type

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ernie - 30 Mar 2007 15:03 GMT

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?

Reply to this Message

Rick Brandt - 30 Mar 2007 15:08 GMT

> 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?

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

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

Signature

Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Reply to this Message