IIf function example

The following example uses the IIf function to return the word "Large" if the value of the Size field is greater than 10000; otherwise, it returns the word "Small".

IIf([Size] > 10000, "Large", "Small")