Identify alpha characters in query

[cunger28]

I'm currently working on an address resolution project and I need to be able
to identify alpha characters in a street number field.

Example: Apt 20

Ideally I'm looking to create an IIF statement that I can use to create a
Flag column and then filter. I know I can use a generic Like criteria, but
it is just not scalable with the amount of day to day activity that occurs.

Thanks,

 

[Douglas J. Steele]

See whether Val([TheField]) = [TheField]

 

[cunger28]

Thanks Douglas,

I think I also had some success with IsNumeric([Field]) as well. I'll
definitely give that option a spin as well.
--
Chris Unger
Analyst - Tyler, TX

See whether Val([TheField]) = [TheField]