>>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 >By the way, thank you for your help! :)