Counting Responses on a Form

[Anagnorisis]

I created a form with fields that are organizations and voting response options. I also have a total field. When voting options are chosen, I want the total field to count the options chosen, but I am trying to get the total count to start over when i click save. Currently, it is not starting over, it keeps counting from where it left off. This is the expression I have in the control source of the total field:



=Count([Army Decision])+Count([CJCS Decision])+Count([DCIO Decision])+Count([DCMO Decision])+Count([DIA Decision])+Count([DISA Decision])+Count([DNICIO Decision])+Count([Navy Decision])+Count([NSA Decision])+Count([UCDSMO Decision])+Count([USAF Decision])+Count([USD(I) Decision])+Count([USMC Decision])+Count([USSTRATCOM Decision])

Should this expression be somewhere else in the property sheet, and is there a way to make the total field start from 0 when I click new record?

Additionally, is there a way to have the Quorum check box automatically select when 11 of the 14 options are selected?

[ranman256]

select Dname, count(Dname) from table
or
select Dname, answer, count(answer) from table