
SELECT DISTINCT and memo field problem?
This is the same as attempting to group by a memo field. This isn't possible
in a standard query. You could possibly write some code that would do this
or try limit your distinctness to 255 characters.
SELECT DISTINCT Left(tblPermitReport.comment,255) As ShortComment
FROM tblPermitReport;
Quote:
> When I attempt to run this:
> SELECT DISTINCT tblPermitReport.comment
> FROM tblPermitReport;
> I get the following message:
> "The field is too small to accept the amount of data you attempted to
> add. Try inserting or pasting less data."
> comment, is a field of type memo, it is not a linked table it is an access
> table, the largest comment is 1572 character long.
> Very annoying. Anyone have any ideas?