subquery

[sabavno]

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]<>&quot;RBFG&quot;,[Name1])

Thanks

 

[shannonp]

Everything is fine up until you get to your Iif statement

&quot;IIf([Count([NewQuery.Name1])=2,[Name1]<>&quot;RBFG&quot;,[Name1])&quot;

Firstly you have a braket that shouldnt be there (see in red)

Also, you can't use a criteria expression when trying to returning a single value (see text in red). Is what you wanted was to do two criteria checks? (Name Count > 2 and Not Equal to &quot;RBFG&quot If so, then you'll have to nest two Iif statements together to handle this. I might have it all wrong, if so please explain what you need your query to achieve.