I'm pulling fields in from a table and I'm checking to see if the item should be in the report. I've typed in the following code:

IIf([InReport1]="Yes", [EmployeeName],)

I want it to only pull in the "Yes" items and I don't want it to leave blanks in the place of the ones with no. The "Yes" items are pulling in but the other items are still holding places in the report.

More Information:

Table is used as RecordSource already predetermined on Load via VBA. Below is what is happening:

Jim Bowie Clerk
Laura Sands Clerk
Joe Brown Sacker
Jimmy Owens Carts

When I type in the code on which to include in report one I get

(Blank)
(Blank)
Jim Bowie Clerk
Laura Sands Clerk

I want it to nullify the top two spots and proceed to just the employees I want in the report.