Recent content by mscant

OK - thanks Minty. I'll have another look at this and maybe get back to you if still no joy.

Dear all, thanks for the replies thus far. Each student has a unique number called a UPN, which I already use as the primary key in the BaseData and DataPt1 tables. Each student studies a number of subjects. For each subject, they may have up to three teachers assigning them a grade. I want to...

Hi Minty, Please see attached. Any help gratefully received. Matt

Thanks Paul - that works great if each student only has one grade. If they have three grades, and I link them all to the Grade field in the GradesToPts table, no records are returned. Any ideas?

I have 3 tables: BaseData DataPt1 GradesToPts The BaseData table contains details about students such as name, gender, etc. The DataPt1 table contains sets of grades for each subject a student studies (e.g. A, B, C). The GradesToPts table contains a set of numerical equivalents to those...