Milt,

SELECT ;
    SUM(IIF(!Empty(...), 1, 0) AS Completed, ;
    SUM(IIF(Empty(...), 1, 0) AS NotCompleted, ;
    ....

>Not really sure what I am doing wrong here. Anyhow I am trying to write an Select statement that will count a field which can either can be empty or completed. In my SQL statement I have COUNT(!EMPTY(subscriber.c_premiumproduct_id)) and COUNT(EMPTY(subscriber.c_premiumproduct_id)). When I run the the select statement I get the same result for both even though I know the result show be 0 for empty and 2 for !empty. Any idea what I made be doing wrong here!