check length of string

[waymond]

I need to run a query that will show all the data that the length is greater than 4 for one field.

than in another query I need to show will the length of the string is 4

thank you

 

[lupins46]

Add another column with the field value as:

MyLen:len([thefieldname])

and put
>4
in the criteria cell.

Use your own field name for 'thefieldname'

Do the same in the second query but just set the criteria value to 4.