If 'Lexp' is a field from the table you are selecting from, try the following:
Select;
TblName.cField,;
IIF(TblName.Lexp = .T., 'Y', 'N'),;
COUNT(*);
FROM TbLName GROUP BY 1,2
-myron kirby-
=====================================================
>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.