Select distinct with memo field

  • Thread starter Thread starter Jerry
  • Start date Start date
J

Jerry

I get a Can't include Memo or OLE Object when you select
unique values (data_cmnt)

Is there a way to get around this
 
You could possibly remove the Distinct and make it a group by that selects
First(Data_Cmnt)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Selecting Distinct Memo Fields 1
Can't group on memo error 1
DISTINCT on a Memo/Text Field 1
cannot have memo,ole or hyperlink object in aggregate argument 2
Union Query with OLE and Memo fields? 4
Memo fields not displaying in query 4
Not In (SELECT DISTINCTROW 13
disctinct query memo field 3

Back
Top