How do I track frequency of occurance in data table?
I have a list of transactions containing part numbers. I need to find out
what part numbers occur the most in the table. I can sort the results, but I
really need the list in order of the most frequently occuring to least
frequently occuring values. The other option would be to get this data from
a report in excel or access I guess. Any suggestions for tracking most
frequently used items from a long transaction log?
Thanks
|