>>Well, here is the exact code, and it includes ItemB (program), which seems to through things off.
>>
>>

>>SELECT     PersonID, Program, COUNT(DISTINCT Program) AS ProgramCount
>>FROM         dbo.tmmLicesnses2Persons
>>WHERE     (DateActivated IS NOT NULL) AND (DateDeactivated IS NULL)
>>GROUP BY PersonID, Program
>>

>
>Not sure what you want, but I suppose you wan to count DISTINCT program for each PersonId:
>

>SELECT     PersonID, Program, Tbl1.ProgramCount
>FROM         dbo.tmmLicesnses2Persons
>INNER JOIN (SELECT PersonID, COUNT(DISTINCT Program) AS ProgramCount
>                   FROM dbo.tmmLicesnses2Persons
>            GROUP BY PersonID) Tbl1
>      ON tmmLicesnses2Persons.PersonID = Tbl1.PersonID
>WHERE     (DateActivated IS NOT NULL) AND (DateDeactivated IS NULL)
>

Great minds... But I think we need to repeat where condition twice (in both selects).