I think you are looking for something like this
Select STATUS, Count(ENTRY_ID) >From MyTable Group By STATUS Fred From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Danny Kellett Sent: Monday, February 02, 2009 8:08 AM To: [email protected] 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"
