You mean count the number of each value?
Select field, count(field) from form group by field From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Danny Kellett Sent: 02 February 2009 14:08 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 __________ Information from ESET NOD32 Antivirus, version of virus signature database 3818 (20090202) __________ The message was checked by ESET NOD32 Antivirus. http://www.eset.com __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"
