Home > IT Answers > Microsoft Windows > Query by character length in Access 2007
Skb1955
10 pts.
 Query by character length in Access 2007
Access 2007, Access 2007 form creation, Access query, Query Calculation
I am wanting to see all the records with 3 or less characters in a specific field. My field contains both text and numbers. How can I do this?

Software/Hardware used:
MS Access 2007
ASKED: October 29, 2010  1:36 PM
UPDATED: October 29, 2010  3:15 PM
RELATED QUESTIONS
Answer Wiki:
You could do it using the <a href="http://www.techonthenet.com/access/functions/string/len.php">Len function</a>. <pre>SELECT * FROM your_table WHERE LEN([your field]) <= 3</pre>
Last Wiki Answer Submitted:  October 29, 2010  3:15 pm  by  carlosdl   63,535 pts.
All Answer Wiki Contributors:  carlosdl   63,535 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _