How to create columns with Count and percentage using MS Access Query
Something like this?

SELECT Person, Count(Person) AS [Count], 100*(Count(Person)/DCount("*","T1")) AS Percentage
FROM T1
GROUP BY Person;