Download User Manual Version 3.0

they become lost or damaged. You want to make a visible reminder on the badge so employees
will be more careful. So, if the badge has been printed two times or more already, you want the
following message to be printed on the badge: “You will have to pay for your next badge!” The
argument for this is as follows:
PrintCount >= “2”
PrintCount is the name of an actual database field which keeps a running count of the
number of times a badge has been printed. >= (the “greater than” and “equals” signs) means
“is greater than or equal to.” You manually type the number 2 and enclose it within quotation
marks. (Literal text or values that *you* supply must be enclosed within quotation marks.)
In the Expression Builder’s Edit window, after you have inserted the IIF function, click your
mouse after the “open parenthesis,” but before the first comma, and type your argument:
[PrintCount] >= “2”
The Edit window should display:
IIF ([PrintCount] >= “2”, , )
Now that the “argument” is created, you must tell Expression Builder what to do if the
argument passes or fails. The syntax of the IIF statement, remember, is IIF (argument, result1,
result2). “Result1” is the “true” result...what should happen if Expression Builder indeed finds
records whose PrintCount is greater than or equal to 2. (In this case, the result you want is text
displayed on the badge.) Therefore, click your mouse between the first and second commas
embedded within the parentheses and type (with quotation marks): “You will have to pay for your
next badge reprint!” (This message will be displayed on every badge that has been printed 2 or
more times.)
If the argument fails—that is, if the badge has NOT been printed 2 or more times—you
don’t want anything printed on the badge. Therefore, click your mouse in the space after the
second comma, and before the closing parenthesis, and type two double-quotes (“”). Two doublequotes, with nothing entered between them, equals “nothing” in Expression Builder.
Your finished IIF statement looks like the following: IIF ([PrintCount] >= “2”, “You will
have to pay for your next badge reprint!”, “”).
162