Select distinct with memo field

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
 
D

Duane Hookom

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

cannot have memo,ole or hyperlink object in aggregate argument 2
Word OLE to check spelling in text box 1
OLE Word spelling 0
Setup and synchronization of Outlook 2016/2019 calendars on iPhone 0
A problem occurred running while microsoft access was communicating with OLE server or ActiveX Control. 0
Not In (SELECT DISTINCTROW 14
disctinct query memo field 3
Selecting Distinct Memo Fields 1

Top