Counting Unique Records in a query ???

[jdowski]

Hi,

I am trying to create a field in a grouping query that counts unique records. I have a query already built that groups loans by property type. For example, in one group, I may have 15 different loans coded "apartment" but only 10 unique customers as one customer may have many loans. So what I want is the count of unique customers in each group, in my example - 10, not just the aggregate count of loans coded "apartment" - 15. I have tried within the grouping query to get a count of social security numbers but I still just get the total record count. What am I doing wrong ????

Joe in Oxford, CT. USA.

 

[PaulF]

Hi

Try a second query based on the first. Query 1 - group by property group by customer. Query 2 -group by property type- count customers.

I think this should work.

 

[jdowski]

Thank you very much Paul !!!!
You're right it worked !

I had been quite a heavy user of the Excel board hear awhile back but never had much luck the Access board but it looks like there's enough traffic on it now get some timely help....

Thanks again Paul !

Joe in Oxford, CT. USA.

Hi

Try a second query based on the first. Query 1 - group by property group by customer. Query 2 -group by property type- count customers.

I think this should work.