excluding minimum number of characters in query

  • Thread starter Thread starter Gary
  • Start date Start date
G

Gary

How can I exclude all data in a field that has less than 7 characters
(And share common alpa prefixes)
 
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
'====================================================
 
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I increase query field length (>20 characters) ? 2
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Query criteria - exclude data and return all records if null 3
Defining Text field sizes in destination Make-Table Query 3
WHERE mystery 2
Exclude Multiple Zeros in Query 4
Like operator with accented character 13
Exclude query data 2

Back
Top