Query

  • Thread starter Thread starter ScubaDee
  • Start date Start date
S

ScubaDee

In a query, is there a criteria that will count the number of characters in a
field... For instance...

Show me records w/ less than 6 characters in FieldA...

Thank you!!
 
As an alternative, you can use

WHERE SomeField NOT LIKE "??????*" Or SomeField is Null

John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
Try len(trim([your field]))

Then, in the criteria cell: <6

Bob
In a query, is there a criteria that will count the number of characters in a
field... For instance...

Show me records w/ less than 6 characters in FieldA...

Thank you!!
Click to expand...
Click to expand...
 
Back
Top