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)"

Out of three workstations tested, this error only occurs on one of them. This wasn't the development machine, but does have Access 2000 like the others Any ideas?

Thanks,
Ray

P.S. - the query is just a simple select statement with one join

 

[wrbodine]

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