Query -Maximum Field Length

[RayToddJr]

I have a field in a table that is a memo field that is used in a report.

What method, if any, can I use to extract all of the data in this field
instead of the first 255 characters?

Thanks,

Ray.

 

[RayToddJr]

I found the answer to my question.

I had the "Distinct" keyword in the query. After removing, it was fixed.

Ray.

 

[Banana]

Good work on finding the answer on your own.

Just for more info: Allen has a nice article discussing what condition
can cause memo truncation.

http://allenbrowne.com/ser-63.html