I'm not sure if this should be in the query or Reports subform, so if it is in the wrong place please move it as needed.
I have a form, SystemPerformance_frm, that allows the user to select and event and open the report, EventSystemPerformance_rpt, filtered to show only the data from the selected Event. Two of the pieces of data that the report displays is BOARunResults and SBIRSRunResults. The possible records for those two fields are Nominal, Off Nominal, and Did Not Participate. I would like to have fields on EventSystemPerformance_rpt that shows the percentage of each of those. Is there a way to have Access count the total number of entries returned and then calculate the percentage of those that are Nominal, Off Nominal, and Did Not Participate.