Hi All,
I have tried various ways of producing what I need, but I am stuck, so hopefully someone can assist me.
I have produced a query, which counts the number of records fulfilling each set of criteria, but I can't now convert that into the matrix presentation.
I think a report is the best option, but I'm not set on it if someone can provide a better answer.
I have a attached a copy of what is produced currently through Excel.
Basically each count on the query represents one of the boxes within the matrix. For example if the record Impact is 1, and the Likelihood is 1, then it would be counted within the bottom left hand box.
Thank you.
I have tried various ways of producing what I need, but I am stuck, so hopefully someone can assist me.
I have produced a query, which counts the number of records fulfilling each set of criteria, but I can't now convert that into the matrix presentation.
I think a report is the best option, but I'm not set on it if someone can provide a better answer.
I have a attached a copy of what is produced currently through Excel.
Basically each count on the query represents one of the boxes within the matrix. For example if the record Impact is 1, and the Likelihood is 1, then it would be counted within the bottom left hand box.
Thank you.
Produce a report matrix
0 commentaires:
Enregistrer un commentaire