Filter on Length

[stuff49]

Anyone know how I can do an advanced filter that will find all records that have 5 characters or less in a text column?

TIA

 

[OnTheFly]

You can do this through a query but I don't think you can do it through a filter.

Hope this helps.

OnTheFly

 

[stuff49]

Ok thanks. Can you tell me what I would place in the Criteria to do this query?

Thank you!

 

[OnTheFly]

For the field you would enter Len(Field1) AS Length Then under that in the Criteria you simply enter 5.


Hope this helps.

OnTheFly

 

[stuff49]

Thank you for your help! That did the trick!