Table/query Struture

[alobi]

I have a vb project, that needs to save and return number_grade, letter_grade and students contact information. I know I need at least two tables,
studenttbl for student information and another for Number_grade, the columns in the tables will look something like this.

English Mathematics History (GradeTbl)
90 80 90


LName FirstName PhoneNumber (Studenttbl)


Mark John 98800000

when students make 90 a letter grade of A is assigned, when the number-grade of 80 a letter_grade of B is assigned my problem is that I do not have an idea where to how to represent this letter_grade in the db and be able to retrieve print in report form as show below

If one can point me to the right direction maybe show me an example or a write up on this, it will be appreciated.

[CJ_London]

you need at least 3 - students, subjects and marks

tblStudents
StudentPK autonumber
StudentName text
...
...

tblSubjects
SubjectPK autonumber
SubjectName text
...
...

tblMarks
MarkPK autonumber
SubjectFK long - link to tblSubjects
StudentFK long - link to tblStudents
Mark integer
...
...

a calculation to convert marks to grades might be

switch(tblmarks.mark>=90,"A",mark>=80,"B",true,"C" )