With one table, it sounds like you may need to normalize your date into several tables.

Look at this link to understand what needs to happen. Once you have normalized data, it will be easier to create your needed query which will act as the record source for your report.

http://sbuweb.tcu.edu/bjones/20263/A...sDB_Design.pdf