This discussion is closed.
GaraK
Badges:
#1
Report 17 years ago
#1
Ok, I have 2 tables, tblcandidate and tblgrades, the fields in tbl candidate are:

candidatenumber,
subjectreference,
originalmark,
originalgrade,
remarkedmark,
remarkedgrade,

and in tblgrades:

subjectreference,
A,
B,
C,
D,
E,

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.
0
X
new posts
Back
to top
Latest
My Feed

See more of what you like on
The Student Room

You can personalise what you see on TSR. Tell us a little about yourself to get started.

Personalise

Regarding Ofqual's most recent update, do you think you will be given a fair grade this summer?

Yes (309)
34.41%
No (589)
65.59%

Watched Threads

View All