Using DCount

[Richard]

Hi

I have a report based on a union query (grouped). A sort of questionnaire
and remarks. For duplicate remarks, it will show as "remarks duplicate (2)"
To achieve this, at the format event of details, I do a dcount of another
similar union query (ungroup). (dcount("*", "QryRemarksUnGroup", "Remarks="
& strRemarks)

All works okay but it takes a long time to process. If I take away the
function, it is 20 times faster but I can't track duplicates.

Is there a way to speed up the process? Hope you understand what I am trying
to achieve here.

Many thanks in advance
Richard