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 write out 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 much in advance.
 
I just want to write out 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 much in advance.
Click to expand...
Select TableName.* From TableName
Where Len([FieldName]) > 100
 
ExcessAccess said:
I just want to write out 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?
Click to expand...


Len(thefield) > 100
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

All records Where [table x].[field x] contains > 100 characters? * 1
Records where [field X] contains 100+ characters ?? 2
records where characters in [field x] > 100 ?? 1
calculation based on previous record 0
Access Dcount (multiple criteria) 3
Criteria of two field values being equal 2
showing records where one field is duplicated and another is not 2
Query field size quandry 2

Back
Top