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

E

ExcessAccess

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

ExcessAccess

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

J

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

Use criterion of
100
Click to expand...
for this field.


--

Ken Snell
<MS ACCESS MVP>

ExcessAccess said:
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.
Click to expand...
Click to expand...
 
Top