>>>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
>>>

>>
>>

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

>
>This returns:
>
>1 P1 1
>1 P2 1
>2 P1 1
>2 P2 1
>3 P2 1
>3 P3 1
>3 P4 1
>3 P5 1
>
>What I need is:
>
>1 P1 2
>1 P2 3
>2 P1 2
>2 P2 3
>3 P2 3
>3 P3 1
>3 P4 1
>3 P5 1

Please see my updated message. You need to use two selects joined.