In Microsoft Access the function used to create an if, then, else formula is IIf and the format is:
IIf (data to be tested, value if true, value if false). The value if false is optional.
In this example IF the home team and visiting teams scores are equal THEN award 1 point, ELSE award 0 points (for clarity I have deleted the part of the formula that awards 3 points for a win).
PointsHome: IIf([HomeScore]=[VisitorScore],1,0))
Copyright © 2026 eLLeNow.com All Rights Reserved.