Can't use memo field when using unique

Hi...

I have a multi user database and one report they frequently use is based on a query that returns unique values with on of the fields being a memo field.
This works just fine on my computer as it does on some others. But a few individuals get and error message saying "Cannot include Memo, OLE or Hyperlinked object when using unique values".

At first I thought it was a version issue: I have Access 2000 (9.0.7616 SP-3) and the first two bugged pple I checked both had Access 2000 (9.0.3821 SR-1). So I installed service pack 3 on these two... but it still doesn't work. I checked their version: 9.0.6926 SP-3 so I thought I need to find a way to bring them up to the same version I am on. But first, I decided to survey my whole group. I found that at least one person with 9.0.3821 SR-1 doesn't get the error.
So my version hypothesis seems invalid.

Anyone has any idea?

Thanks

I can't imagine grouping by a memo field. However, you might want to try
"First" rather than "Group By" in the query.

--
Duane Hookom
MS Access MVP


"Peter-Dave" wrote in message
...
Hi...

I have a multi user database and one report they frequently use is based
on a query that returns unique values with on of the fields being a memo
field.
This works just fine on my computer as it does on some others. But a few
individuals get and error message saying "Cannot include Memo, OLE or
Hyperlinked object when using unique values".

At first I thought it was a version issue: I have Access 2000 (9.0.7616
SP-3) and the first two bugged pple I checked both had Access 2000 (9.0.3821
SR-1). So I installed service pack 3 on these two... but it still doesn't
work. I checked their version: 9.0.6926 SP-3 so I thought I need to find a
way to bring them up to the same version I am on. But first, I decided to
survey my whole group. I found that at least one person with 9.0.3821 SR-1
doesn't get the error.
So my version hypothesis seems invalid.

Anyone has any idea?

Thanks

Let me give you some more details...

-I have a tblStudy table which includes a title field which is of type memo.
-I have another table which will list multiple audits for each records in the study table (tblAudits).
-I am generating a report which lists all the audits for a given study (the study id is chosen based on the current record id in the form that calls the report). The report header includes the study title and the details section lists all audit types. However, if I have multiple audits of the same audit type, I only want to display it once. I tried just setting the "hide duplicate" property in the report to true, but that leaves a blank line btween the record that contains duplicates and the next record.

Here is what my query looks like:

SELECT DISTINCT tblStudy.Title, tblStudy.StudyNumber, tblAudits.PhaseType
FROM tblAudits INNER JOIN tblStudy ON tblAudits.ProjectId = tblStudy.ProjectId;

Like I said, this works on some computer and not on others.

Thanks

Actually I found my problem. SOme users have Windows 2000 SP2 and others SP3.
As part of the SP3, the Jet engine was ugraded from SP5 to 6 or above.

thanks anyways