If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Counting Checkboxes
How can I count the number of checked checkboxes on a
report? I want to get a percentage, so I need: (Number of Checked Checkboxes/Total Number of Checkboxes)* 100. Thanks you |
#2
|
|||
|
|||
Counting Checkboxes
On Mon, 24 May 2004 11:32:14 -0700, quixote wrote:
How can I count the number of checked checkboxes on a report? I want to get a percentage, so I need: (Number of Checked Checkboxes/Total Number of Checkboxes)* 100. Thanks you In the Report Footer: =ABS(SUM([CheckBoxField]))/COUNT([CheckBoxField])*100 The Sum function of Check boxes will return the number of checked boxes. The ABS() function will make the result a positive value. The Count() function will get the total number in the report (checked and unchecked). -- Fred Please only reply to this newsgroup. I do not reply to personal email. |
Thread Tools | |
Display Modes | |
|
|