|Figure 1: An Access Table containing|
Subject and Result fields.
IIf(Conditional Expression, True_Condition, False_Condition)
IIf([Result] > 50, "Pass", "Fail")
|Figure 2: The IIf Function has been entered into the third column using the alias Pass.|
Now lets run the query and see what we get:
|Figure 3: the results of our query to calculate whether|
a student has passed or failed an exam.