query to find records that don't contain any numbers 1

[ironj32]

I need to run a query that returns records that do not contain any numbers. I'm not sure what the criteria would be? Also it would be nice to do the opposite, return a query that returns records that do not have any letters.
thanks!

 

[mhartman1]

Hello:

More information is needed, like what field, or a clearer explanation. Are the numbers inter-mixed with alpha characters?

Regards
Mark

 

[ironj32]

it is a text field "floors"

example of records:
1st
main
ground
2
skyway
3
1
2nd floor

i would like to run a query that will show me only the records that do not have any numbers in them

 

[PHV]

In the criteria cell of floor:
Not Like '*#*'

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[ironj32]

thank you