Selecting the numeric portion of a text field

[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

 

[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

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

Joop