Try this Bob.

SELECT

    [USERNAME],

    SUM(CASE WHEN [STATE] = 'TX' THEN 1 ELSE 0 END) 'TX',

    SUM(CASE WHEN [STATE] = 'NM' THEN 1 ELSE 0 END) 'NM',

    SUM(CASE WHEN [STATE] =...

Thanks. 

SELECT   GroupCode,COUNT(*) as myCount,

   SUM(CASE WHEN Compliant = 'T' THEN 1 ELSE 0 END ) AS Compliant

FROM      myTbl

GROUP BY  GroupCode

Still evaluating, but certainly looks promising. 

Wish List:

Ability to rearrange objects.

Sent to file or printer.