Hello friends,
I have a field column containing lots of data - blanks, words and sentences. I need to create a query criteria to filter data which is longer than 0 but no longer than 5.
in the query criteria I put Len([])>"0" and it works nice - all blanks are gone. It also works if I put 1 - then I see only strings longer than 1.
But it does not work other way around: Len([])<"5" - I suppose to see only strings which are less than 5 characters in lengt, but I still see long strings... like 20 characters.. Please help
Bookmarks