excluding minimum number of characters in query

G

Gary

How can I exclude all data in a field that has less than 7 characters
(And share common alpa prefixes)
 
J

John Spencer

Use criteria of

NOT LIKE "???????"

IF you have specific leading characters then

NOT LIKE "AXY????"

Warning this will exclude records where the field's value is null. So
you might want the criteria to be

NOT LIKE "AXY????" Or IS Null

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
'====================================================
 
G

Gary

Thank You

John Spencer said:
Use criteria of

NOT LIKE "???????"

IF you have specific leading characters then

NOT LIKE "AXY????"

Warning this will exclude records where the field's value is null. So
you might want the criteria to be

NOT LIKE "AXY????" Or IS Null

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
'====================================================
Click to expand...
 
Top