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

E

ExcessAccess

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.
 
N

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
 
Top