Danny,

Select distinct count(Selection_field) from Table;

Joe



________________________________
From: Danny Kellett <[email protected]>
To: [email protected]
Sent: Monday, February 2, 2009 9:08:08 AM
Subject: SQL to get counts on distinct values

**  
Hi All,
 
Anyone have the sql that would give me a count of every distinct
value in a selection field?
 
Many thanks
Danny



_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
      

Reply via email to