Report controls

[Guest_imported]

my question goes...<br>Well, i am creating a report that uses yes/no for data tables. The report has checkboxes that indicate whether a criteria has been met. For example, if i have three people in the report and each one fills the criteria in which they make over $500 per week, they will have a check in the columns under &quot;&gt;$500 /wk&quot; My problem is trying to create a total of the number of check boxes displayed on the very bottom row. Using the example above, i should get three for the total. But i have no idea how to create the control/write the procedure for the count. Can someone PLEASE help. Thanks!

 

[famousb]

i think that the DCount function should work well for you:<br><b><br>= DCount(&quot;<font color=red>[Yes/NoField]</font>&quot;, &quot;<font color=red>TableOrQueryReportSource</font>&quot;, &quot;<font color=red>[Yes/NoField]</font> = -1&quot<br></b><br><br>change the red to fit your situation, and this should work for you, and yes, you must leave the quotes and you must have a table or query that the checkboxes come from - DCount can't just refer to the report itself. <p>Brian Famous<br><a href=mailto:bfamous@ncdoi.net>bfamous@ncdoi.net</a><br><a href= > </a><br>