I created a database to manage the Advanced Placement (AP) program at my high school. I am trying to create a layout that displays the total number of test takers and the total number of tests administered (some students are taking multiple tests). I used a field with check boxes to indicate which of up to 10 tests each student is signed up for. How do I define a field for my summary layout which allows me to display the total number of tests to be administered ( I already figured out how to display the total number of test takers)

When you say "tests to be administered" Does one student sitting 3 tests mean 3 tests are to be administered?

sounds like 'tests administered' would just be a sum all?

so if for each test for each person =1

then sum the lot to give a total.

Yes, most students are sitting for multiple tests, so the number of tests taken will be more than double the number of test takers.

You need to calculate how many tests each student has checked:

ValueCount ( CheckboxField )

Then summarize the result using a summary field (Total of CalcField).

For more detailed reports you will need to add a join table of SignUps between Students and Tests, instead of the checkbox field.