Calculating totals with checkboxes

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

Guest

On my report I'm trying to calculate how many checkboxes are checked off for
a certain category, but I can't figure out what I should put for the
countrolsource. Can someone help me??
 
On my report I'm trying to calculate how many checkboxes are checked off for
a certain category, but I can't figure out what I should put for the
countrolsource. Can someone help me??
Click to expand...

Use an unbound control.
=Abs(Sum([CheckBoxName]))
 
What do you mean by an unbound control?

fredg said:
On my report I'm trying to calculate how many checkboxes are checked off for
a certain category, but I can't figure out what I should put for the
countrolsource. Can someone help me??
Click to expand...

Use an unbound control.
=Abs(Sum([CheckBoxName]))
Click to expand...
 
What do you mean by an unbound control?

fredg said:
On my report I'm trying to calculate how many checkboxes are checked off for
a certain category, but I can't figure out what I should put for the
countrolsource. Can someone help me??
Click to expand...

Use an unbound control.
=Abs(Sum([CheckBoxName]))
Click to expand...
Click to expand...

It means the control source of the control is NOT bound to any field
in the table. Also make sure the name of this control is not
"CheckBoxName".
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

fake checkbox based off lookup column 2
Calculated Totals 7
Yes/No checkboxes 2
Access 2007: How to center checkbox under label? 7
Totalling check boxes 5
Access Reports and uses of Textboxes 1
Checkbox magic needed... (remove...) 2
Setting checkbox state thru code 1

Back
Top