All records Where [table x].[field x] contains > 100 characters? *

[Guest]

I just want to create a query that returns all records (from a single
table)where a particular field contains more than 100 characters. Can
someone please tell me how to properly write out this criteria?

Thanks in advance.

 

[Nikos Yannacopoulos]

Make a plain Select query on the table, adding all required records to the
grid. Then add a calculated field like:

Expr1: Len([FieldName])

and type 100 in its first criterion line. Uncheck the Show checkbox if you
don't want the lenght number displayed.

HTH,
Nikos