query with memo field not working

[wrbodine]

Hi,

I'm using a query in Access 2000, that blows up on a memo field with the following error:

"Cannot include Memo, OLE, or Hyperlink Object when you select unique values (tblCustomers.Comments)"

This error only occurs on one of my co-workers machine (who also has Access 2000). Any ideas?

Thanks,
Ray

 

[cmmrfrds]

Are you trying to include the memo field in an aggregation??
This would include things like group by, max, min, etc..

Certain data types cannot be part of an aggregrated query.

 

[wrbodine]

Its just a simple select statement, that joins with one other lookup table, no aggregration. What's wierd is that it works fine on 2 other workstations....

 

[wrbodine]

Someone pointed out the answer to me; in the query properties "Unique values" had been set to "Yes" and needed to be "No"!!