simple select query blowing up on memo fieldHi,, , In Access 2000, a query performing a simple select statement is giving the following error:, , Cannot include Memo, OLE, or Hyperlink Object when you select unique values (tblCustomers.Comments)., , The Comments field above is a Memo field. , , The interesting thing is that this error only occurs on one of our developer's workstations; the query works fine on the other 2. All 3 use Access 2000., , Any ideas??, Thanks,, Ray  wrBodine | Someone pointed out the answer to me; in the query properties "Unique values" had been set to "Yes" and needed to be "No"!! :) |
|