Counting DISTINCT records in a Report

[Jake]

Hi

I have a report where I have a textbox which is counting the number of
contracts for each particular office.

However, I wish to see only the DISTINCT count ie excluding any duplicates.
How do I do this in the textbox control source on the report?

I cannot eliminate the duplicates in the query because I need the values of
other fields which means that I will always have contract numbers duplicated
!!!

How do I eliminate duplicates in a report's text box using COUNT?

Many thanks

Jake

 

[Jeff Boyce]

Jake

Not sure I understand. It sounds like an Office can have one/more
Contracts. And it sounds like a Contract can have one/more ????. You said
there are "duplicates" ... duplicating what? Which fields are the same and
which contain values that differ?

More info, please...

Jeff Boyce
<Access MVP>