Query to display entries of 14 characters or more

[ssyah]

Hello,


I have a table (containing over 100,000 entries) which has a (text) field containing entires ranging from 1 character to 17 characters long. I am triying to create a query which will only list entries which have 14 or more characters. Can someone help me on this please?

[RuralGuy]

Where Len([YourField] > 13

[ssyah]

Where Len([YourField] > 13

Hi RuralGuy,

I have tried this and a lot of variations of the this and when I run the query it is still lists entries < 13 characters long.

I have found a work around - where Len([YourField])="14", Len([YourField])="15", Len([YourField])="16" etc all work so i can run these and then append them I get the same result. This is a tad time-consuming so I would appreciate it if somebody could give me the code to run it all in one go.

thanks again!

[RuralGuy]

Add another field to your query set to =Len([YourField]) and then add a criteria of > 13

[ssyah]

Add another field to your query set to =Len([YourField]) and then add a criteria of > 13

I had just found the solution. Thanks all the same RuralGuy.

[RuralGuy]

What was the solution you found?