In this post I will explain how to create an Access report that has subtotals and percentage formulas. The first step is to ask the question for which the report will answer. Lets look at the screenshot below and ask “Which country has the highest units sold?” and “What is the percentage of the total units sold per country?” We will group the report by country which has United States, Canada, Brazil and the Dominican Republic.
First click the Insert tab and chose report wizard.
Select the table(s) or query you want to work with.
Select the fields you want to be included in the report.
Group by country.
Select summary options.
Click sum and check the box to calculate percent of total for sums.
Name the report and click finish.
You could touch up the report by clicking on the design view.