Query -Maximum Field Length

R

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

RayToddJr

I found the answer to my question.

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

Ray.
 

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

Query field size quandry 2
disctinct query memo field 3
memo field in the select query 2
How can I convert text field to memo field in a query 10
Append to SQL Server 3
update query - memo field 5
Query Truncating Memo Field 9
Query Returns First 255 Characters of Memo Field 2

Top