I received some help eariler to help me with a calculation on a report which works until I add more records to my table. I have a simple form that ties to one table. The form has two drop down lists. One is for area audited (example: FWV, CVT) the other is a choice of audits (Completed Audits, Unsafe Audits, Safe Audits). I have a query that will count the total number of audits which is tied into a report. The report has a calculation to give a percentage of unsafe audits / completed audits. If I enter four records for say CVT and based on my query it calculates 3 Completed Audits and 1 Unsafe Audit the percentage is correct on my report (33%). The problem is if I introduce more records but add FWV my calculation for the query remains correct but the report to get the percentage is calculating all the records. I am looking for I guess what I would call sub totals. So I would expect to see something like this.
CVT Unsafe Audits 1
Completed Audits 3
Percentage of Unsafe audits 33%
FWV33 Unsafe Audits 1
Completed Audits 2
Percentage of Unsafe auditis 50%
Right now on my report I get a percentage for both as a grand total. I have attached my db In the hopes that somebody can help me fill in the blanks as I'm sure this is a simple fix.