need help with subquery

[polina]

Hi,

I have this subquery that does not work

If anyone could take a look at that, I'd appreciate it

SELECT NewQuery.Name1, NewQuery.TRANSIT, NewQuery.OP_STATUS, NewQuery.GL_INPUT_TYP
FROM NewQuery
where NewQuery.Name1=
IIf([Count([NewQuery.Name1])=2,[Name1]<>"RBFG",[Name1])

Thanks

 

[Jon K]

WHERE IIf((Select Count([Name1]) from NewQuery) =2, [Name1]<>"RBFG", [Name1]=[Name1]);