T
Tony Benham
My son has a problem in MS Access he cannot solve, (unfortunately I'm don't
know Access at all.)
He has a main table containing a primary key candidateno, and records
subjectno,and mark(a %) (among others).
He has another grade table with subjectno as a primary key, which has for
each subjectno, a set of records showing the mark required for each grade
A,B,C,D,E,U.
What he would like to do is to generate a query and/or report which takes
the subjectno and mark for each candidate, looks up the data in the grade
table using the subjectno, and then using the mark calculates the grade
using the figures in the table for that subject no.
How might this be done ?
Regards
Tony B
know Access at all.)
He has a main table containing a primary key candidateno, and records
subjectno,and mark(a %) (among others).
He has another grade table with subjectno as a primary key, which has for
each subjectno, a set of records showing the mark required for each grade
A,B,C,D,E,U.
What he would like to do is to generate a query and/or report which takes
the subjectno and mark for each candidate, looks up the data in the grade
table using the subjectno, and then using the mark calculates the grade
using the figures in the table for that subject no.
How might this be done ?
Regards
Tony B