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! <br>

 

[DougP]

The &quot;Count&quot; function will do the job.<br>You have to decide which field to use it on<br><br>=Count([Fieldname])<br>Or maybe<br>IIF (CheckBoxfield.Value = True, Count([CheckBoxfield]),&quot;&quot<br><br>The first one I think will just count everyhting Checked or not.<br>The IIF is an If statement that will only count something if it's checked. So if the field that is a yes/no is checked then count them else don't count.<br> <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.