query that selects based upon number of characters

  • Thread starter Thread starter Jennifer K.
  • Start date Start date
J

Jennifer K.

I have a field that can be up to 4 characters such as:

C619
A52
C343
C32

I would like to select the records that have only 3 characters and would
give me only the records such as A52 and C32 in the results.

Thanks!
Jennifer
 
Use criteria of
LIKE "???"
against the field.

Or use a calculated field to get the length the field's content.

Field: FldLength: Len([Your Field])
Criteria: = 3

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
'====================================================
 
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

Help with query multiple records into one 5
Querying for Extended ASCII Characters 1
Query for # character not working 2
retrieve last three characters of field 2
Select Query Criteria 4
Query number of characters in a field 2
Strip leading characters from field name 14
Query number of characters in a field 2

Back
Top