Trying to calculate the percentages. So far I have a code that counts the results and displays them. This code is here:
SELECT LitOrigName.litName AS Originator, Count(LitOrigName.litName) AS [Number Of Members]
FROM MemberMasterTable INNER JOIN LitOrigName ON FellowshipMasterTable.litID = LitOrigName.litID
GROUP BY LitOrigName.litName;
Now, I would like to calculate the percentages of each result. The Originator column produces 5 different results, with the first result displaying a count of 200 out of a total of 549. I want to create a percentage column that displays the results, so the first result would produce a percentage result of 36.4% from 200/549.