Jump to content

calculating total of Value List items


RHB47
 Share

This topic is 5699 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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)

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 5699 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.