Dup recordeds being counted

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report created that i'm counting on a field a certian field. When i
count on this field it gives me a total of 861. This field has 2 items that
are dupped so i want to count it as 1 and not as 2 sdo my total is 860. My
report is based off a query. I tried make my query pull in only distinc
records but this did not work due that both records are unique. Where is an
example of what the records look like. The first line is column name and the
second is the data.

Auditor Qc Auditor Loan ID Exception Description
Date
Adam Tom 123456 500 margin incorrect
4/15/2005
Adam Tom 123456 501 Date incorrect
4/15/2005

I want to count the loan in my report as 1 and the exceptions in my report
as 2. Can some one please help?
 
Adam. what you could do is add a second query, where you count unique values
for the Auditor, this would give you the desired number.
Now you can add this query to source of your report.
Hope this helps.
Fons
 
Back
Top