How eliminate duplicate memo columns?

[Guest]

I've run into a serious problem 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?

 

[Guest]

What is your table structure. You might try doing the Distinct part of the
queries without the memo field, then link that subquery back to the table to
get the entire memo field.

 

[John Spencer]

By the way, the list box will truncate any fields passed into it to a max of
255 characters per column.



--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..