What you show is a spreadsheet.
If you set up a properly normalized relational database, that report output could be difficult to produce. Best case would mean a couple of CROSSTAB queries could accomplish, if not, will require VBA code.
Review the 'sticky' thread tutorials at http://forums.aspfree.com/microsoft-access-help-18/
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.
Thank you very much.
I've done on this.