How to make a field that is a summary of unique values for multiple fields.
I have one table that is called "Evaluations" Each Evaluations record has 19 eval fields (evalA, EvalB, EvalC). Each field has one evaluation result from a value list of 7 options.
****The reason for keeping all the evaluations as one record is because it relates to a certain item that has those evaluations and certain groups (2 other tables)****
My problem is that I want to count how many of each value list option is in each field for each evaluation in a "dyamic" report without having to make 60 calc fields.
EvalA I need to know how many of Value list option1, option2, option3, option4, option 5 for Eval A
for Eval B I need to know how many of Value list Option1, option2. option3, option 4, option 5 for Eval B
this would repeat for all evals.
The table should look something like this.
EvalA EvalB EvalC ......
valuelistchoice1total 2 4 6
valuelistchoice 2 total 4 0 3
valuelistchoice 3 total 1 1 2
Is this possible???? Any help would be great! Thank You