I have a table where 25 codes are captured. The underlying columns in the database are:
Code1 Code2 .. .. Code25 I need to extract a list of DISTINCT values entered in ALL of the columns, and the count of each of those values across all 25 columns. Note that it is possible to have NO value in a given field. Over all 25 columns, there are a total of 9770 values (not distint) so we are talking about a fair number of entries. Desired result is something like this: Code Count 123.4 115 124.6 101 .. .. .. What is the most efficient way to do this? CF6.1 Win2k3 Server Access 2002 TIA, Tim ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please delete it from your system. This footnote also confirms that this email message has been swept for the presence of computer viruses. Thank You, Viahealth ********************************************************************** ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188261 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
