Adding another group provides even better information to know the average number for each party for the year and month Add a second grouping field between the Month and Numin Party fields . The field should display the four digit year in the Service Date field Name the new field Year . Sort by Year in ascending order Run the query . Save and close the query