Show all records with more than x characters (1 Viewer)

[GoodLife22]

I have a text field. I want to see all records in my table which have more than 17 characters. I am sure this is super easy, but I have never done it. Thank you.

 

[Mr. B]

Create a column in your query that uses the Len() function to return the length of the value in each row returned by your query and make the critera for this field to b > 17.

 

[GoodLife22]

that did it. Thank you Mr. B!