Records where [field X] contains 100+ characters ??

[Guest]

I just want to query records where a particular field contains more than 100
characers. How do I write this criteria out?

Thanks much, in advance.

 

[Ken Snell [MVP]]

Add a created field to your query:
FieldLength: Len([FieldName])

Use criterion of

100

for this field.

 

[Guest]

Thanks much for the assistance, and apologies for duplicate postings. Lots
of odd errors while trying to post.

J

Add a created field to your query:
FieldLength: Len([FieldName])

Use criterion of

100

for this field.


--

Ken Snell
<MS ACCESS MVP>

I just want to query records where a particular field contains more than 100
characers. How do I write this criteria out?

Thanks much, in advance.