If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Converting letter case | Sonic | General Discussion | 1 | August 12th, 2004 03:16 AM |
Letter grade display | Jer53621 | Worksheet Functions | 2 | March 31st, 2004 01:16 AM |
Grade Book project | Emma | Worksheet Functions | 3 | October 24th, 2003 04:29 PM |