Memo column problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
mscertified said:
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.
Click to expand...


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.
 
Back
Top