The formula you're showing would work well for a formula to show data on a report. However, it will not work in the selection criteria as it returns a string, not a boolean. To use this in the selection criteria, you would have to do two things:
1. Join FROM the name table TO the appraisal table. Right-click on the join, select Link Options and make this a "Left Outer" join. This will give you all of the records from the name table regardless of whether they have data in the appraisal table.
2. If you want to just show the names that do NOT have an appraisal, put the following in the selection formula:
IsNull({appraisal.field})
This will return true when there is no appraisal record.
-Dell