Count Field Size

B

bdehning

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?
 
B

bdehning

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