Want a Access Report that will do the following
Print each group, give the number attending for that group, give the number not attending for that group, and give the % attending.
Sample:
Groups Attending Dropped % Attending
1st Group 90 10 90%
2nd Group 18 6 75%
Each record has the group name and a check box for attending
I can get the following output, but I need to know how to get it in the format above with the % attending.
What I get now:
1st Group
90 Attending
10 Dropped
2nd Group
18 Attending
6 Dropped
Print each group, give the number attending for that group, give the number not attending for that group, and give the % attending.
Sample:
Groups Attending Dropped % Attending
1st Group 90 10 90%
2nd Group 18 6 75%
Each record has the group name and a check box for attending
I can get the following output, but I need to know how to get it in the format above with the % attending.
What I get now:
1st Group
90 Attending
10 Dropped
2nd Group
18 Attending
6 Dropped