Try

SELECT EMPLOYEE, type, count( distinct type + STR(ORDER_NO,10) ) as NUM_ORDS 
FROM mytable 
group by EMPLOYEE, type ;
INTO CURSOR crsTemp
SELECT EMPLOYEE, SUM(IIF(type="A", NUM_ORDS,0) AS cnt_a, ...
FROM crsTemp;
group by EMPLOYEE

>Sergey,
>
>Your approach will count total number of A orders and B orders. But I want to count number of UNIQUE orders. In example below George had 2 unique B orders yet he had 3 total B orders.
>
>Thank you.
>