Can't use memo field when using unique

[Guest]

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

 

[Duane Hookom]

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

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.

 

[Guest]

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.PhaseTyp
FROM tblAudits INNER JOIN tblStudy ON tblAudits.ProjectId = tblStudy.ProjectId

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

Thank