Custom Calculated Field

There are six tests that all of our BPA member students can take in addition to the two specialized events they enter. The students can take none or all of theses "Open" events. They are typically multiple choice in nature and usually consist of 50 questions. We often have ties, for example two or more students may get 46 questions correct.

No ties are allowed in any contest, and considering that we give plaques to the top three in each contest, but recognize the top ten with certificates, it becomes important to break all ties. That is why we have all student write the start and stop time at the top of their test sheet. If we have a tie we break it by who finished the test quickest.

We are going to a computer based testing system this next year for these six tests. I will be able to download the results into Excel, which I will then be able to import into Access. The computer keeps track of the start and stop time. I've added a custom calculated field that subtracts these two times. I've additionally set the query to sort first by score and second by time. This creates a table which can be run into a report for documentation of the contest. See Financial Math in the Queries portion in my database.