I am trying to create a database report for work and I'm not sure if this question is more of a report question or a query question. The purpose is to track certain types of activities that will be reported to funders. One activity will be trainings provided to other people and the funder asks for the number of people trained in specific categories of professions and then the topics trained on. The number of people is pretty basic for me (I'm a self-taught advanced novice). What I'm struggling with is creating a report on the topics trained. The table would have the following fields (hypothetically):
ID
ActivityDate (necessary as reports are for specific periods of time)
Math: y/n
History: y/n
English: y/n
Band: y/n
(yes, I understand normalization rules would probably move the activity date out of this table and into a separate table that is linked to each of the other tables, but just throwing it in here to show the need for or purpose of the date)
What I would like to do is be able to run a report that will list the categories of topics with a checked box if that topic was covered and an unchecked box if it is not covered in a training. I know the easier report would be based on a query that just finds those topics checked as yes, but I would like to format the report to mirror the question on funders actual report. In other words I would like the access report to list every option available, but only put a check mark next to it if there was a yes response. Keep in mind that there could be multiple trainings through the report period so a table might look like this:
ID Date Math History English Band
1 1/5/13 y n y n
2 2/14/13 n n y y
I would like the report to then look like this:
Period: 01/01/13 to 06/30/13
Math: <x>
History: < >
English: <x>
Band: <x>
Is there a simple way to format a report around a yes/no response like this?