Suggestions for Simple VBA

[n107jkx]

I have a percentage worked out for my students' test and homework scores in an Access database of my students and their performances. Is it possible, presumably using some simple VBA, to apply a grade as a new field, which depends on how good the percentage is?

e.g. A student scores 40 out of 50, which works out to be 80%.
Given:

80% is an A,
70% is a B,
60% is a C, etc.

The grade field should show an A.

Any help would be much appreciated.

 

[n107jkx]

I still need some help if any1 else wants to contribute !!

 

[bat17]

In a module add the following code and save the module with a differnt name than the function.
From a query you would call it with something like Score:GetScores([MyPercentage]) where [MyPercentage] is the field where you have worked out your pecentage.

Function GetScores(dblScoreIn As Double)
Select Case dblScoreIn
Case Is >= 80
   GetScores = "A"
Case Is >= 70
   GetScores = "B"
Case Is >= 60
   GetScores = "C"
Case Else
   GetScores = "Fail"
End Select
End Function

 

[n107jkx]

Thats EXCELlent.

Thanks v. much