Query Formula - Awarding Grades
Posted on 2003-03-10
Well, my question is an important one but it should be easy for some to answer with advanced experience of MS Access:
The general aim of my case study is to produce a database which manages the re-marking of examination scripts.
I have two tables; One with candidate and the other with subject information (which includes grade boundaries).
With a query, I would like to link these tables so that I can produce a number of results that the case study requires of me.
What formula would you suggest I use if I wanted a field to produce the "grade" (e.g. A,B,C) using the information of "mark" and "maxmark"?
Thank you for reading my question. :-)