Count Field Size

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

Guest

I have a table with a field called Comments.

If I am using

SELECT [Request For Loss Control Service].COMMENTS
FROM [Request For Loss Control Service]
where

What do I use for where to find the records where comment field has more
than 3000 characters?
 
WHERE Len([Request For Loss Control Service].COMMENTS) > 3000
 
Thank You very much.

Worked Great
--
Brian


Douglas J. Steele said:
WHERE Len([Request For Loss Control Service].COMMENTS) > 3000

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



bdehning said:
I have a table with a field called Comments.

If I am using

SELECT [Request For Loss Control Service].COMMENTS
FROM [Request For Loss Control Service]
where

What do I use for where to find the records where comment field has more
than 3000 characters?
Click to expand...
Click to expand...
 
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

columnhistory 4
Entering LF/CR special characters in a Memo field 2
Text field size 4
Add field to Access view of Sharepoint database 1
Counting unique records 9
looking for strategy for subForm filter 6
Memo Field in Table Truncated in query results and in report 1
count related records 2

Back
Top