Perfect, thank you
Kind regards From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Grooms, Frederick W Sent: 02 February 2009 14:13 To: [email protected] Subject: Re: SQL to get counts on distinct values ** 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 __Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
