How can I add Summary Fields in Access 2007 Reports? First of all the reason why you might want to add a summary or SUM field to a report is to include and SUM or add up all the data in your selected group. For example, you have a a candy shop and you're selling only to large distributors. So you may want to group the candy you sell, and under each group you have a listing of all those candy stores who have purchased that specific type of candy in the past. So you may want to keep track of your total candy purchased by all those stores. Add a SUM field that calculated the total purchased of each store under that group i.e. gummy bears, lollipops, candy canes etc.

Purchase the training video and you can see this in action for yourself!