View Single Post
  #1 (permalink)  
Old June 17th, 2015, 10:38 PM
honey_mags honey_mags is offline
Registered User
Points: 5, Level: 1
Points: 5, Level: 1 Points: 5, Level: 1 Points: 5, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2015
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Get the percentage of the count result

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?