Count Unique Entries

[Guest]

I am trying to run this sql with the count of unique customers. I have a
large DB and need to know how many customers I have by each mkt segment by
region.

SELECT [Natl Reg POS August 2004].Region, [Natl Reg POS August 2004].[Mkt
Segment], [Natl Reg POS August 2004].Customer
FROM [Natl Reg POS August 2004];

 

[John Vinson]

I am trying to run this sql with the count of unique customers. I have a
large DB and need to know how many customers I have by each mkt segment by
region.

Thanks for the clarification of the question.

SELECT [Natl Reg POS August 2004].Region, [Natl Reg POS August
2004].[Mkt
Segment], Count([Natl Reg POS August 2004].Customer)
FROM [Natl Reg POS August 2004]
GROUP BY [Natl Reg POS August 2004].Region, [Natl Reg POS August
2004].[Mkt Segment];


John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps