Calculating % based on information in rows

[NAP50]

I have a table which contains a list of closed cases along with column called closure code. For example closure code "34" might mean a case was closed because the client was no longer interested in buying a product.



I would like to somehow create a report that details the % of cases that were closed with a closure code of "34".

Please could someone advise the best way of doing so?

[ranman256]

Make a query Q1 that sums all cases.
and Q2 that sums cases with only 34.
then a query Q3 that calcs the pct, Q2.Sum34 / Q1.TotalAll

[NAP50]

Thanks Ranman!