F
fastandbad
Hi. I am organizing a large school fair. There are many jobs at the
fair, and two shifts of each job, Many people are volunteering for
each activity. So I have a table of 'Participants', and I have a
table called "Activities", with many "Yes/No" Fields that are marked
depending on if the person is volunteering. I then have about 20
quieries, which show, as an example, the names of all the people who
volunteered to work at the Popcorn stand. What I want to do now is
have a final report that will print all the different activities
(Popcorn, cotton candy, etc.) on each row, and each column will list
who volunteered on the first shift (column 1) and the second shift
(column 2).
I am having trouble doing this, because Access gives me an error
saying there is no relation between the different activities, so it
doesn't understand how I want to group them together.
If someone would have an example or could point me in the right
direction of how to assemble this kind of report, I'd really
appreciate it. Thanks very much.
fair, and two shifts of each job, Many people are volunteering for
each activity. So I have a table of 'Participants', and I have a
table called "Activities", with many "Yes/No" Fields that are marked
depending on if the person is volunteering. I then have about 20
quieries, which show, as an example, the names of all the people who
volunteered to work at the Popcorn stand. What I want to do now is
have a final report that will print all the different activities
(Popcorn, cotton candy, etc.) on each row, and each column will list
who volunteered on the first shift (column 1) and the second shift
(column 2).
I am having trouble doing this, because Access gives me an error
saying there is no relation between the different activities, so it
doesn't understand how I want to group them together.
If someone would have an example or could point me in the right
direction of how to assemble this kind of report, I'd really
appreciate it. Thanks very much.