Database alternative

[Mike from Moriches]

I need to develop a "vote counter" routine and would like a running total
for each candidate. Assume I have 5 candidates running for office in a
3,000 person community. I know I can add a row to a database for each vote
cast on the website, then count rows for each candidate each time a total is
requested. I would prefer to have a table (MS Access) with just 5 rows, one
for each candidate, then do a candidate_A_count = candidate_A_count + 1 for
each vote cast for candidate A, etc. That way I always have up-to-date
totals. Is this possible? If so, can you provide me with a coding concept
to accomplish this objective?
TIA,
Mike from Moriches

 

[Stefan B Rusynko]

Take a look at any of the free online Polls
- See http://www.expinion.net/Applications/PP_overview.asp

You'll need to add member login and tracking to make sure they can only vote once

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


I need to develop a "vote counter" routine and would like a running total
for each candidate. Assume I have 5 candidates running for office in a
3,000 person community. I know I can add a row to a database for each vote
cast on the website, then count rows for each candidate each time a total is
requested. I would prefer to have a table (MS Access) with just 5 rows, one
for each candidate, then do a candidate_A_count = candidate_A_count + 1 for
each vote cast for candidate A, etc. That way I always have up-to-date
totals. Is this possible? If so, can you provide me with a coding concept
to accomplish this objective?
TIA,
Mike from Moriches

 

[Mike from Moriches]

Thanks Stefan
Looks like PollPro should do the job!
Mike