How do I "count" ticks?

[confidego]

Hi everyone,



I have attached two screenshots for your perusal.

In the images, you can see that "Total Paper-Back(s)" counts for the number of the boxes. I require it to count the number of ticked boxes and non-ticked boxes.

Is there anything I can do to rectify this problem?

In the design view, I used =Count(*) to count the number of boxes.

If it is impossible, would be better to remove "tick" as a mean but use "Yes/No" lookup wizard, or purely text??

[June7]

I am confused by this report setup. The Count is cumulative for the BookType. Is this what you want? Aggregate calcs in the PaperBack & NotPaperBack textboxes will also be cumulative. Why aren't the records in the Detail Section? Is there anything in the Book Code Footer (you show nothing in Header)?

Can you make project available (or at least objects related to this issue)?

[rpeare]

a yes/no fields is stored as -1/0 if you count them you are going to get a count of all fields, which you did.

If you want to count only the paperbacks you would do abs(sum([paperbackyesno])). Abs takes the absolute value of a number (makes a negative number a positive) so for instance in the book section where you have one item checked and another not you would get a value of 1.