Memo Truncation in Query

[Guest]

Is there a way to get my Memo field to not cut off the last characters when I
pull it into a select query?

 

[Rick B]

This was just asked yesterday. I think the answer was that it will be
truncated if you are sorint or grouping on that field. Do a search and see
what the answer was.

Rick B

 

[Rick B]

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.