If/then entry on report

[madwoman]

Hi

I am generating a report which shows exam results. My results table contains 6 different exams in the table and against each exam there is a single letter value for the actual results (eg P, F, C, D). When I display the result for each exam in the report I want to display the following as appropriate to the value held in the table:
P - display "Pass"
F - display "Fail"
C - display "Pass with credit"
D - display "Pass with Distinction"
How would I do this.
Apologies if I am missing the obvious

 

[grnzbra]

In the query driving the report, create a field with the IIf statement:

IIf(Results = "P","Pass",IIf(Results = "F","Fail", IIf(Results = "C", "Pass with credit", "Pass with distinction)))

Use this field to drive the field on the report

 

[madwoman]

That works fine, thanks very much