I’m stuck. I have a table with about 30 fields. Each contains numeric values ranging from 0-5. I need to COUNT each value, on each field. It should looks something like this:
Vals. Fld1 Fld2 ....etc.
0_____30____55_____….
1_____24____10_____….
2_____16____55_____….
3_____33____98_____….
4_____77____22_____….
5_____80____180____….


I want to be able to do this in the least typing possible, that’s why I thought of a query. Now, I know selecting the count is not the problem, but identifying the values of each count is what I can’t figure out.
thanks in advance