How to count discrete values from separate fields?
I'm short of coffee this morning so maybe that's why I can't find/figure out an answer to a problem I need to solve: I need to count the number of discrete values from separate fields; I've found info on something like it on the Web for when you want to count discrete values in _one_ field but not from _many_ fields.
Example: You have five fields, each one assigned a numerical value:
DB1 = 1
DB2 = 3
DB3 = 2
DB4 = 3
DB5 = 1
So, the result I'm looking for should look like this:
Count of 1s: 2
Count of 2s: 1
Count of 3s: 2
Count of 4s: 0
Suggestions and help will be greatly appreciated. Thanks!