restricting character lengh

[ghayman73]

is it possible to run a qry that will pull out all words that have more than 25 charaters.

i have tried this in the criteria of the qry.

Len([keyword])>25

but with no luck. any ides how to solve this i have used this before but on a form and it worked fine.

thanks Grant

 

[PaulF]

create an expression field for each field that you want to test, and use the Len() function for each one, and then enter >25 for the Criteria Row for each of these expression fields, just don't place the >25 on the same row for each of these fields because it will become and AND statement instead of an OR statement

Exp1: Len(YourFieldName)


PaulF

 

[ghayman73]

thanks PaulF