F Fred W Feb 26, 2004 #1 I am trying to create a query that will return values that do not contain any letters. Thank you, Fred
I am trying to create a query that will return values that do not contain any letters. Thank you, Fred
G Guest Feb 26, 2004 #2 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
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) Feb 27, 2004 #3 Since "1" is a valid character, I think you might need to change this to Not Like "*[A-Z]*"
