Counting Tick Boxes.

[Tom Transfield]

When you count tick boxes they are counted as -1. How do you convert the
Minus numbers to positive numbers.

I have read the Microsoft solution but is appears to only relate the Report
footers.

Is there a way to do it in the query design view some how.

Kind regards.

Tom Transfield
From the land down under....

 

[Guest]

You can multiply by -1 or ABS([YourCalculatedField]).

 

[fredg]

When you count tick boxes they are counted as -1. How do you convert the
Minus numbers to positive numbers.

I have read the Microsoft solution but is appears to only relate the Report
footers.

Is there a way to do it in the query design view some how.

Kind regards.

Tom Transfield
From the land down under....

Using an unbound text control in a report:
= Abs(Sum([CheckBoxField]))
will return the count of how many boxes are checked (as a positive
number).

In a query:
SELECT tblBasicData.CheckField, Sum(Abs([CheckField])) AS
CountOfChecked
FROM tblBasicData
GROUP BY tblBasicData.CheckField;

I would do it in the report.