When I run the following

Select cField, iif(Lexp,'Y','N'), COUNT(*) from table group by 1,2

It groups by the iif statement properly, but populates all of the second field with the .f. iif value--'N'. The exception is when the group of field1 only has representatives of the .t. iif value, and then populates the one field with 'Y'.

I frequently use IIF in SQL and occassionally run into this problem. Does anyone know why?

Thanks in advance for your assistance.