Count Unique Entries

  • Thread starter Thread starter Guest
  • Start date Start date
G

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

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
 
Back
Top