Query Criteria - Does not contain Number

LB79

Registered User.
Local time
Today, 22:04
Joined
Oct 26, 2007
Messages
505
Hi all,

Hope you had a nice Easter.
Wonder if anyone can help me with this?
I have a query that I need to filter out all items that contain numbers.
EG - AAA, BBB, CCC will show but A1A, BB2, 3CC, will not show.

Is there a way to set the criteria this way? 'Is Not Like *#*'??

Thanks
 
Just answered my own question... Its works using # as number.
 

Users who are viewing this thread

Back
Top Bottom