Counting Checked Boxes

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

Guest

I have read all the postings and suggestions on this problem and I am not having any luck
I am having a little difficulty with my report
First: I query on the dates: to get the month reporting
Next: I need to total each checked box receive a total

I have 12 places where one checks yes or no. (examp: MOTION, FTA, SHOW CAUSE, REVW...

I have tried
=Abs([MOTION]), =Count([MOTION]), =Sum(Abs([MOTION]), and even =Sum(Abs([MOTION]="yes"))

I am either comming us with #Error or I am comming up with )...

HELP...thanks in advanc

Regina
 
Hi Regina
I suspect the probelem you are running into is that the
textbox is named the same as your data element (I suspect
motion). Change the name to something else and make sure
the formula in the text box is still correct since
autocorrect can make some changes.
Now Abs([Motion]]) or where applicable Sum(Abs([Motion])
should work just fine.
You probably should check this on all your textboxes with
formulas.
Hope this helps.
Fons
-----Original Message-----
I have read all the postings and suggestions on this
Click to expand...
problem and I am not having any luck.
I am having a little difficulty with my report.
First: I query on the dates: to get the month reporting.
Next: I need to total each checked box receive a total.

I have 12 places where one checks yes or no. (examp:
Click to expand...
MOTION, FTA, SHOW CAUSE, REVW...)
I have tried:
=Abs([MOTION]), =Count([MOTION]), =Sum(Abs([MOTION]), and
Click to expand...
even =Sum(Abs([MOTION]="yes")).
 
Back
Top