Poll count

Results 1 to 2 of 2

Thread: Poll count

  1. #1
    Join Date
    Dec 1969

    Default Poll count

    I&#039;m making a poll on my website. When a user submits a vote, it saves their IP address (so they can&#039;t vote twice) and what they vote for. I have no problem with this.<BR><BR>Now for showing the results, I need to write an SQL query the will return the total number of votes for each category. I&#039;d rather not have to do a database call for each category, is there a way I can return the number of votes for each all in one recordset??? I&#039;m using access so I don&#039;t have access to views and not sure about stored procedures, I&#039;ve never used those in access, I ussually use Microsoft SQL.

  2. #2
    Join Date
    Dec 1969

    Default Use GROUP BY with an aggregate func <eop>


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts