Counting Distinct Records

[Susan]

I have a report that I need to count the distinct records.

I have Borrowers SSN. Each borrower can have one or many loans.

I need a report that will provide a count of SSN (Distinct), and Loan id's
(Distinct as well) it is really a count on loan number and a count distinct
onSSn. I have a grouping by the School, since that is also needed, and the
report needs to display by school.

Any ideas?

 

[John Vinson]

I have a report that I need to count the distinct records.

I have Borrowers SSN. Each borrower can have one or many loans.

I need a report that will provide a count of SSN (Distinct), and Loan id's
(Distinct as well) it is really a count on loan number and a count distinct
onSSn. I have a grouping by the School, since that is also needed, and the
report needs to display by school.

Any ideas?

Unfortunately JET (the Access database engine) doesn't support the
COUNT DISTINCT predicate. Try creating a query with a DISTINCT clause
and basing your count on that.

John W. Vinson[MVP]

 

[himis]

I have a report that I need to count the distinct records.

I have Borrowers SSN. Each borrower can have one or many loans.

I need a report that will provide a count of SSN (Distinct), and Loan id's
(Distinct as well) it is really a count on loan number and a count distinct
onSSn. I have a grouping by the School, since that is also needed, and the
report needs to display by school.

Any ideas?