Not sure if this shld be done in a query or report

[MSIG]

I have a table which collects responses for questions in an office. There are abt 50 questions per form. Each questions response is a YES/NO/NA. Once all the forms are collected in a table. I need to total/sum up the repsonses grouping up them by office.
Example Central Region office
Yes No NA
Was documentation good 5 2 1
Was it properly filed 3 5 1


and so on. How do I proceed? Thanks for all the help in advance


MSIG

 

[lark_tilly]

If your data is stored like the following, I don't see how you'll do this with simple queries-> office..question..answer
If it was stored like-> office..question..N..Y..N where the Y would represent "No" then it wouldn't be a problem.
I can see doing what you want with code by reading the data and writing it to a another table in the format you'd need to report the way you want to.
If this is something you do a lot of then it might be worth exploring that approach.