Student grades, converting numerical to letter grade

We have a dual system of grading in the UK. Both letters and corresponding
numerical values are used. They may be input as numerical ie 55% but may then
be issued as letter grades or vice versa. I have calcultaed weighted averages
using a query and thought the logical operator "between" might work but no
success yet. Help please.

Assuming a numeric field named "Marks", you should be able to lookup the
corresponding grade letter by entering a calculated field like this:
=DLookup("Grade", "GradeTable", "Marks = " & Nz([Marks],0))

DLookup() is slow if you are trying to do this on every row of a query. If
you don't mind a read-only result (e.g. for a report), you can use a
subquery to get the grade. Type something like this into the Field row in
query design view:
GradeLetter: ( SELECT First(Grade) FROM GradeTable
WHERE StudentResults.Marks = GradeTable.Marks )

The example assumes that the student marks are contained in a table called
StudentResults.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Alan in Canterbury" wrote in
message
...
We have a dual system of grading in the UK. Both letters and corresponding
numerical values are used. They may be input as numerical ie 55% but may
then
be issued as letter grades or vice versa. I have calcultaed weighted
averages
using a query and thought the logical operator "between" might work but no
success yet. Help please.