Here are the posts I mentioned...
----------------------------------------------------------------------------
-
It only truncates the memo field if you:
- sort on the field
- group by the field in a Totals query
- specify a Format on the field
If you don't do any of these things, you should see the full memo
field. Just including it in a Query does NOT truncate it.
If you're using a Totals query as the basis for the report, use First
as the grouping operator for the memo field rather than Group By.
Hopefully you don't actually need to group by the *contents* of the
memo field (this would occur only if you had records which were
identical in all other fields and only had differences in the memo).
John W. Vinson[MVP]
----------------------------------------------------------------------------
-
I believe it also truncates if you use SELECT DISTINCT, or UNION.
UNION ALL will solve the problem for the last case.