Selecting the numeric portion of a text field

D

DougJrs

Good Afternoon Everyone!

I am having a little trouble figuring out how to select only the
numeric portion of a text field. I have a text field in Access that
stores both letters and numbers and all I want is the numeric part of
the field. Anyone have an Idea how I can do this:

Here are some examples:

11P
4A
3AB

I just want the first numerics from the field, so 11, 4, and 3.

Thanks,
Doug
 
J

Joop Kuijntjes

Good Afternoon Everyone!

I am having a little trouble figuring out how to select only the
numeric portion of a text field. I have a text field in Access that
stores both letters and numbers and all I want is the numeric part of
the field. Anyone have an Idea how I can do this:

Here are some examples:

11P
4A
3AB

I just want the first numerics from the field, so 11, 4, and 3.

Thanks,
Doug
Click to expand...


If the numbers are always in front of the letters you can use
val(Yourfield)

Joop
 
Top