Fields from Tables

[JuniorWoodchuck24]

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.

 

[JuniorWoodchuck24]

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.