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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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
 
Back
Top