Integer Query

F

Fred W

I am trying to create a query that will return values that
do not contain any letters.

Thank you,

Fred
 
H

Howard Brody

Try

Not Like "*?*

as the criteria (and check the Help files for details on Wildcards



----- Fred W wrote: ----

I am trying to create a query that will return values that
do not contain any letters.

Thank you

Fre
 
J

John Spencer (MVP)

Since "1" is a valid character, I think you might need to change this to

Not Like "*[A-Z]*"
 
Top