Query

[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!!

 

[ScubaDee]

Nevermind... I discovered the len() function!

Thanks!

 

[John Spencer]

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!!