I have set up an Access database showing test results. My manager wants to see the progress between two consecutive tests. The results are alphanumeric rather than numeric and so the difference cannot easily be calculated. I have set up a separate table giving each level a corresponding number but I haven't got a clue how to write the code to firstly lookup the numeric value for both sets of results and then take one away from the other.
Could anyone give me an idea of how to do this ?