How to pull 1000 characters

  • Thread starter Thread starter JA
  • Start date Start date
J

JA

Is there a way to pull records where one of the fields has 1000 or less
characters?

Thank you,

JA
 
Hi JA

Use a select query with criterion:

Len([SomeField]) <= 1000

Also, consult the help facility regarding Trim, LTrim, and RTrim if leading
or trailing spaces in the field matter to you.

HTH,
Immanuel Sibero
 

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

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Top N Records on multiple fields 14
Truncate 1
Separating Parent and Child Fields 7
Access Running Balance in Access 1
Query returns Arabic and/or sanskrit characters 4
Select Query Criteria 4
return record if 5th character is a letter 4

Back
Top