Show only certain text in a query

[Guest]

Hi!
I have a field in a table that can have 200 characters.

I want to run a query that will show me all the records in that field that
have more than 40 characters in that field.


Thanks

 

[Duane Hookom]

Use a where clause of something like:
WHERE Len([YourField])>40