Getting Access to calculate Exam grades

[NiallO]

i was wondering is it possible to get access to calculate a grade on the basis of an exam mark? I have created a table with attributes, subject, grade, grade boundary, eg Maths, A, 67. So how do I get access to allow me to select a subject (i know how to do that part), and then whatever mark that person got in that subject to diplay the appropriate grade? Must I use like an IF THEN ? Or ?? I know that in Excel it's like IF, VLOOKUP, but i don't know about access

 

[Rich]

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=45931

 

[norman]

A very similar question was asked during the lasweek. Use search with 'grades' as the keyword and limit the search to 1 week or newer. The thread was by Armin .

HTH

Norman

 

[NiallO]

Hey thanks for the thread link, it's help me understand what I have to base my problem on, however, it doesn't solve the problem, because, i must have table with a list of the subjects with their unique grade boundaries, i.e. to obtain a grade A in one subject may require 90, whereas in another it could be 65. How would I go about doing this? I know that I would have to select the subject, from a list, and enter a mark, but how would I get the required grade to appear?

 

[NiallO]

Hmm, what I said previously doesn't make much sense. I have followed the armin thread link, and i have created 5 modules, each representing 5 subjects with their uniqe grade boundaries using the IF ElseIf. So how do I link these modules together, so that they can be used in a query. Or, should I have all the subjects in the one module, with their grade boundaries, and use this to create a query? If so, how would I go about doing this?

 

[NiallO]

Here is my problem