Show only certain text in a query

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

Guest

Hi!
I have a field in a table that can have 200 characters.

I want to run a query that will show me all the records in that field that
have more than 40 characters in that field.


Thanks
 
Use a where clause of something like:
WHERE Len([YourField])>40
 
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

Count text values in a Access Field 0
Query field size quandry 2
Make table query: [Enter 1] AS Test 1
Query Exceeds the limit of data for a single record 7
Extracting a word from a long text field 5
Make Table Query Truncating Memo Field at 255 Characters 2
Query 2
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0

Back
Top