Thanks for the responses. I am quickly becoming more and more educated with access, but have only slightly dived in to VBA code so I dont have the knowledge to know what code to write yet for my issue.
Any further guidance would be greatly appreciated.

Thank you!

I am trying to generate a report that will provide information on whether a unit participated in an event or not utilizing the Yes/No check box. The problem is that I have over 40 units to identify in this report, and can not fit the unit identifier (headers) across the top of a single page.
Since I will never have more than 20 units participating in a single event, and that amount of headers would fit on a single page. Is their a way to...