7 Replies Latest reply on Nov 10, 2013 7:31 AM by philmodjunk

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

    ChristinaMoore

      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.