Access SQL HelpWatch
and in tblgrades:
With the letter fields containing the minimum mark needed to achieve that grade.
I need an sql statement for access that will automatically reference the marks in tblcandidate to the grade boundaries in tblgrades and add them into the originalgrade and remarkedgrade fields in tblcandidate.
Can someone help me with this since I don't have a clue.
Our teacher who taught us this stuff was crap and I just can't figure it.