>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
Edgar,
I'm not sure I understood it. Would you get something like :
0 = 30+55...
1 = 24+10... ?
Cetin