How do you use if then and else statements in Microsoft access 2003?

Microsoft

1 answer

Answer

1037606

2026-05-03 04:35

+ Follow

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))

ReportLike(0ShareFavorite

Copyright © 2026 eLLeNow.com All Rights Reserved.