Memo column problem

[Guest]

I've run into a serious pronblem with memo columns being truncated. Whenever
i do a SELECT Distinct or a UNION query my memo fields are truncated.
My database as a table called Issues which has a memo column. Issues are
assigned to Rules and Rules assigned to Packages. The same issue may apply to
different rules assigned to the same package.
This is my problem, how do I list all the Issues for a Package and get rid
of the duplicates and yet retain the full memo column. So far all attempts
have failed.
The solution needs to be a query as it has to feed a Listbox and also a
report.
Any ideas?

 

[Marshall Barton]

I've run into a serious pronblem with memo columns being truncated. Whenever
i do a SELECT Distinct or a UNION query my memo fields are truncated.
My database as a table called Issues which has a memo column. Issues are
assigned to Rules and Rules assigned to Packages. The same issue may apply to
different rules assigned to the same package.
This is my problem, how do I list all the Issues for a Package and get rid
of the duplicates and yet retain the full memo column. So far all attempts
have failed.
The solution needs to be a query as it has to feed a Listbox and also a
report.

I have replied to this same question in two of your other
threads in two other groups on this same issue.

Please don't multipost.