Vote Tally / Count Appearance Within Value List / Poll Tally / Count Occurrences of Value
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.