I am using an access database that has an auto number primary key and 10 columns i.e. ID,num1,num2,num3,num4,num5,num6,num7,num8,num9,num10
Each column has numbers ranging from 1 to 100 I want to find out how many times. each number occurs over all the columns i.e. 100 - 72 times 99 - 5 times 98 16 times Then i want to sort the result by the number of times Anyone? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:352783 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
