User guide

Appendix A: Creating expressions and filters 99
4. Click OK until you reach the Field Properties window.
Now you need to set up your conditional filter for the Expression field that tells
Label Toolbox when to print “Current Resident.” To do this:
1. Click the Filter Builder button next to the Conditional Filter box. In the
Filter Browser window, click New. In the Filter Builder window, type a name
for your new conditional filter, such as Empty Name.
2. In the Filter Syntax box, type empty(DB.FIRST).OR.empty(DB.LAST).
For more practice, try building the filter by selecting and adding the
necessary fields, functions, and operators.
3. Click OK until you reach your design window.
You now have told Label Toolbox to print “Current Resident” in the Expression
field when either of the fields DB.FIRST or DB.LAST are empty. However, if
one field is empty, Current Resident will print and so will the other name field.
Because you do not want to have a name like “John Current Resident” on your
label, we need to tell Label Toolbox that, if one field is empty, it should not print
the other name field.
To do this, we need to set up two more conditional filters: one for the DB.FIRST
field and one for the DB.LAST field:
1. Select the DB.FIRST field. In the Field properties window, click the Filter
Builder button next the Conditional Filter box. In the Filter Browser window,
click New.
2. Type a name for your new conditional filter, such as First.
3. In the Filter Syntax box, type .Not.empty(DB.LAST).
4. Click OK.
Repeat the process for your DB.LAST field. Name your conditional filter Last
and in the Filter Syntax box, type .Not.empty(DB.FIRST).