Listbox sorting and comparing and tally
Posted on 2002-06-11
I know I can do this but time is not permitting so perhaps someone here may have a snippet of code that will come close to what I need.
I have a list box with a lsit of things.
1/4 Hex Nut
Wall screw Alloy
1/3 Hex Nut
2/3 Lug Nut
1/2 Driver nut
Dry wall nail
1/4 Ply wood
Hex Screw Black
Okay, we have the list. Here is what I need to do. I need to tally how many of each item are there. Keep in mind the list will change from time to time. So, I need a tally of how many general categories I have so the return should come back 5-Nut, 2-Screw, 1-Bolt, 2-Nail, 1-Wood
Perhaps I will have to create a definitions table of general items, so lets assume I have that for the list to relate to. if there is a way to do this without using a definition table then the better because this list is very dynamic.
Okay, I think you have the scenario. If you need more info please ask away.