calculating total of Value List items

[RHB47]

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)

[Genx]

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

[Twd70]

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.

[RHB47]

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

[comment]

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.