Options:
1. aggregate query
2. report using Sorting & Grouping with aggregates calc in textbox - allows viewing detail data as well summary calcs
This is basic Access functionality. Should be able to find many examples and tutorials if you don't have an introductory book.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.