AnsweredAssumed Answered

Vote Tally / Count Appearance Within Value List / Poll Tally / Count Occurrences of Value

Question asked by ChristinaMoore on Nov 8, 2013
Latest reply on Nov 10, 2013 by philmodjunk

Title

Vote Tally / Count Appearance Within Value List / Poll Tally / Count Occurrences of Value

Post

     I am working on an assignment where I have to keep records of a poll and report ongoing tallies of the ongoing survey.

     I have written a VERY simple database to do so.

     Fields in the database are simple:

(1) Subject's Name

(2) Subject's Choice (which contains the subject's poll response)

     And so a typical record might look like:

Mrs. Jane Doe

[said she'd vote for] Barack Obama

     and the next record might look like:

Mr. John Doe

[said he'd vote for] Mitt Romney

     For the Subject's Choice field, I have it populated with a pulldown menu that is from a value list called Candidates.

Thus, I create a new record when I interview a new subject, and then I click on the response field, and up pops "Barack Obama" "Mitt Romney" or "Someone Else."

I want to keep a running tally of the poll results.  I would like a field or report or whatever that simply counts how many times someone chose Obama, Romney, or Someone Else in this VALUE LIST.

     Please help.  It's driving me crazy.

     And thank you in advance.

      

      

Outcomes