Search with OLE or hyperlink field 1

[rjmccafferty]

I have a query that searches only text and number fields. But I am getting the following message when I search with one specific field in the results and ask for unique values in the query properties. The message I get is:

"Cannot include memo, OLE or Hyperlink object when you select unique values [pipeline.LastResults]" where [pipeline].[LastResults] are a table and field names.

If I strip out this field, all is fine with the query, including other fields from this table. If I strip the query down to just this field, I still get the error message.

I suspect we have pasted some offending entry in the some record(s). How do I try to figure out what and where the offending entry(s) are?

 

[tlbroadbent]

What data type is the offending column, LastResults? You cannot select Distinct (Unique) if the column is a Memmo, Ole or Hyperlink data type. That is the essence of the message. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[rjmccafferty]

Yes, I understand the meaning of the message. As I stated, all the fields in the original query were either text or number. LastResults is a simple text field.