Either join the queries and use report Sorting & Grouping features or use report/subreport arrangement. Without knowing your database structure, hard to advise specifics.
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.