Formatting calculations on a report

[Nashskye13]

I created this database. The user is now asking me if I can add percentages to the reports. How many errors vs. records and also a percentage of each reason code. Can someone advise me as the best practice on handling this? I have been researching this but I believe I have only confused myself. I have attached the database. All of the records on the table are not real and for testing purposes only.

[June7]

Which report - all of them?

Suggest you use report Grouping & Sorting with aggregate calcs functionality. Group on the reason code. Calculate count in group footer. Calculated count in report footer. Expression in textbox ControlSource: =Count([Reason Code]). Divide group count by footer counter.

Expression for Decision Error count in group footer: =Sum(IIf([Decision Error]=Yes,1,0))

All of the reports have input parameter prompts. Personally, I NEVER use input prompts. I use reference to form controls as parameters.