Column Counts

  • Thread starter Thread starter MB
  • Start date Start date
M

MB

I tried to figure it out with "Help" but I'm lost.

I have a report with fields that are checkboxes. I have
them in a columnar report. I know how to do =Count(*)
for all records, but what do I do for a count of each
checked box in each column? (I.e., column headings: $
Paid; Student; Speaker; Registered.

I'm working on Access XP.

Thank you so much!

MB
 
The checkboxes actually represent values that are True (-1) or False (0).
Sum the field, and take its absolute value to determine the number of
checked boxes.
 
Thank you for replying. I'm a novice at Access. How
exactly do I sum the field and take its absolute value to
determine the number of checked boxes?

Thanks again for your time.

MB
 
I figured out how to apply "=SUM" to each field, but I
keep getting a negative number. How do I change this to
a positive?

Thanks again!
 
THANK YOU!
-----Original Message-----
Either put a minus sign in front of Sum(MyField), or use the Abs function to
give you the absolute value (Abs(Sum(MyField))).

--
Doug Steele, Microsoft Access MVP






.
Click to expand...
 
Back
Top