ACCESS: How do you calcualte tick boxes... PLEASE HELP! THANKS

[Guest]

ACCESS: How do you calcualte tick boxes to get the total of boxes.

I am doing a supporters club booking system for Leeds United, (for school
A2) I have a field with every match, then on the left, the members are
listed, you go across the table and tick the maches for each member.

I need a total amount of games eahc member is goign to (ticked) and a total
amount of mebembers goign to each match.

HOW IS THIS DONE.

PLEASE, PLEASE HELP! THANKS ALLOT

 

[Duane Hookom]

Do you have a table structure that you would like to share? I hope you don't
need to add across fields rather than across records.

One hint might be that the value of a checked box is -1 and an unchecked box
=0.

 

[Guest]

Thanks allot for your reply.

I do, I think want to do both of what you suggested. But, if you could help
me out with how to add this up, that would be wonderful!

Below is the concerned table, (a screenshot) I can send the whole access if
your willing to look at this.

BTW, do you work for MS or are you just being very nice?

THANKS SO MUCH!!! THANKS, I APPRECIATE IT

 

[Duane Hookom]

I assume this thread is continued in a new thread that you started. This is
generally not a good practice.