Duplicates in report

  • 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. Can
some one please help?
 
Hi, Adam.

If you're not already, base your report on a query rather than the table
itself. To select only unique records, the syntax in SQL is SELECT DISTINCT
rather than SELECT. You can also do this in Query Design View by
right-clicking the query window, selecting Properties, and changing the
UniqueValues property to Yes.

Hope that helps.
Sprinks
 
Sprinks,

My report is based off a query. I tried what you stated and it did not
work. This is 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.
 
Back
Top