Can't include Memo or Long Binary when you select unique values (Item).

Error 3114

Remove the DISTINCT reserved word43US84.

See Also

ALL, DISTINCT, DISTINCTROW Predicates (SQL)JQ3FN7

SELECT Statement (SQL)ZUPF0W