Query results from Iif statment confusing

[tfaiers]

I've got an unbound form which has a field that I need to relate to from a query, I've got no problems relating to specific records, but I've not quite cracked the ability to select all other records if the field is left at 0.

I've tried using in the query under the 'table' field (for selecting a specific group of people seated at a particular table)

Iif([Forms]![TablePlannerFrm]![TableSel]=0,>0,[Forms]![TablePlannerFrm]![TableSel])

Which I thought would evaluate a true/false with the two results coming from the two options, so if the Table selected on the unbound form was set to 0 then it would set the criteria to >0 (everything table 1 and up), or if anything else was selected other than 0, it would use the number from the unbound form from the TableSel field.

I'm getting blank results from both positive and negative results. I assume that I'm not using the Iif statement correctly, or that there is another way of approaching the problem that my headache is blocking

Thanks everyone

 

[Jon K]

You can put the criteria in a new column in the query grid like this:-

-----------------------------
Field: IIf([Forms]![TablePlannerFrm]![TableSel]=0, True,

=[Forms]![TablePlannerFrm]![TableSel])

Show: uncheck

Criteria: True
-----------------------------
.