Are there Data size limits in an ACCESS query?

[Dave]

I have a table with a lot of memo fields.

When I run an ACCESS query memo fielda are treated as a text field and
characters are cut off the Query Results.

If I reduce the number of fields in the query, all of the memo data is
displayed.

So the question - are there size restrictions for a query using memo fields
and if so is there a work around?

Thanks

 

[Rick B]

This is posted pretty often. I think it is normally caused by the fact that
you are sorting or grouping by the memo field.

Rick B

 

[Dave]

I found it after I changed my search.

In my case, it was because I used DISTINCT is the SQL.

Thanks for responding.

Dave