Counting Distinct Records

G

Guest

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?
 
J

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?
Click to expand...

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]
 
H

himis

Susan said:
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?
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting Distinct Values 1
count question 3
counting distinct records 4
Count of distinct records for each group header 9
Distinct Count in Crosstab 1
counting distinct from a query 2
How to get a count of items in a Select Distinct query? 2
Select Distinct Question 1

Top