SELECT  tlp.PersonID, tlp.Program, 
		( SELECT COUNT(*) FROM dbo.tmmLicesnses2Persons tlp2 
			WHERE tlp2.Program = tlp.Program 
				AND (DateActivated IS NOT NULL) AND (DateDeactivated IS NULL)) AS ProgramCount
	FROM   dbo.tmmLicesnses2Persons tlp
	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