<p>I've created a table that will tally the number of rows where a column (Contam) is equal to 1. </p>
<p> </p>
<p>The next step is to give the user the ability to modify that row. I've created a form that works really when the report is initially run:</p>
<pre class="_prettyXprint _lang-html">
<form name="frm_mine">
<select name="select_contamination">
<OPTION value="0"></OPTION>
<OPTION value="1" <VALUE-OF>if (row["Contam"] == 1){
"selected='selected'";
}</VALUE-OF> >Yes</OPTION>
<OPTION value="0">No</OPTION>
</select>
</form>
</pre>
<p>Produces what I'm looking for:</p>
<p><img src="
http://i.imgur.com/mABJIrh.png" alt="mABJIrh.png"></p>
<p> </p>
<p> </p>
<p>My question: How can I get a total of the number of items marked as "Yes" and more importantly, recalculate when one of them changes?</p>
<p> </p>
<p> </p>
<p>Thanks in advance</p>
<p> </p>
<p>Tom</p>