>>So has anyone else had the same experience this morning? It's yet another geek barometer ..... Every time I read a newspaper headline with the word "recount" I say it to myself as "record count."
>>
>>"Voters await record count in Florida."
>
>It is time for web-based voting. With rushmore the prez would have been known in .75 seconds of the polls closing in Hawaii.
>
>

>SELECT count(id) as votes, candidate ;
>  FROM VOTES ;
>  WHERE voter = registered ;
>  GROUP by candidate ;
>  ORDER by 1 DESC ;
>  INTO CURSOR cElectionResults
>

can I make a slight change?

SELECT count(id) as votes, candidate ;
  FROM VOTES ;
  WHERE voter = registered ;
  <strong>AND party = "R" ;</strong>
  GROUP by candidate ;
  ORDER by 1 DESC ;
  INTO CURSOR cElectionResults

(VBG) 8-P