 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Queries / May 2008Query
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!! Nevermind... I discovered the len() function! Thanks! > 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!! 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!! 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])) > [quoted text clipped - 8 lines] >> >> Thank you!! |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.