Hello ma'am/sir, i am asking your big help for this...
I am developing an Online Voting System in ASP.NET with the database from MS ACCESS, i'm having a problem in getting the percentage results in vote count instead of integer.
Here is my query:
Code:
SELECT COUNT(Result.gov) AS countgov, tblCandidates.[Full Name] FROM (Result INNER JOIN tblCandidates ON Result.gov = tblCandidates.ID) GROUP BY tblCandidates.[Full Name] HAVING (COUNT(Result.gov) > 0) ORDER BY COUNT(Result.gov) DESC
PLEASE SOMEBODY HELP ME?