On Thu, 09 Mar 2006 22:06:11 -0500, dad <ja********@cox.net> wrote:
I need help writing a query to display all boxes that are checked for
a particular record. I have ten possible check boxes for each record
and each record will have different boxes checked. Any help would be
greatly appreciated. Thanks.
Add a calculated field (CheckCount) to your query which is a sum of all 10
checkboxes.
CheckCount:[Checkbox1]+[Checkbox2]+[Checkbox3]+[Checkbox4] etc
In the criteria line under this field put <>0
If no checkboxes are ticked, CheckCount will return 0 and be excluded from the
dataset. If 1 or more checkboxes is ticked CheckCount will return between -1 and
-10 depending on the number of checkboxes ticked, and will be included in the
dataset.
Wayne Gillespie
Gosford NSW Australia