Access Reports

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to create a report using Access 2002. On the footer section, I am
trying to sum check boxes that are checked "TRUE". My first attempt is
coutning the boxes instead of the "TRUE" fileds. For example, I have 11 check
boxes but only 3 are "TRUE". When I use the count function, I get 11 instead
of 3. I tried using "if" or "count if", but none work.

Please help.

Thank You in advance.

Lax2Sea
 
I am trying to create a report using Access 2002. On the footer section, I am
trying to sum check boxes that are checked "TRUE". My first attempt is
coutning the boxes instead of the "TRUE" fileds. For example, I have 11 check
boxes but only 3 are "TRUE". When I use the count function, I get 11 instead
of 3. I tried using "if" or "count if", but none work.

Please help.

Thank You in advance.

Lax2Sea
Click to expand...

In what Footer?
You cannot do any summing in the Page Footer.
If it is in the Report footer or Group footer, use:
=ABS(Sum([CheckBoxName]))

If you are trying to use the Page Footer, read
Microsoft KnowledgeBase article
132017 "How to sum a column of numbers in a report by page?
 
That did it! Thanks! I was trying to put the sum formula in the iif condition
instead of outside.

Ofer said:
Try this

=Sum(iif([Check Box Name]=True,1,0))
--
I hope that helped
Good luck


Lax2Sea said:
I am trying to create a report using Access 2002. On the footer section, I am
trying to sum check boxes that are checked "TRUE". My first attempt is
coutning the boxes instead of the "TRUE" fileds. For example, I have 11 check
boxes but only 3 are "TRUE". When I use the count function, I get 11 instead
of 3. I tried using "if" or "count if", but none work.

Please help.

Thank You in advance.

Lax2Sea
Click to expand...
Click to expand...
 
Back
Top