counting yes or no

C

count yes or no

i put "=Sum(Abs([YourCheckBox])" in controlsource but it is not working.How
can i do it right.plz help.
 
K

Klatuu

There is nothing to sum in a control source. Only one record is presented at
a time. Perhaps if you can explain WHAT you want to do, we can help with the
HOW to do it.
 
N

NG

Hi,

in the control source property of a control on a form or report you have to
use a domain function, I suppose you could use something like:
= DCount("[MyYesNoField]";"[TableName]"; "[MyYesNoField] = -1")
 
B

BruceM

The expression using Sum and Abs would do the same thing, as long as it has
enough closing parentheses, as Karl pointed out.

NG said:
Hi,

in the control source property of a control on a form or report you have
to
use a domain function, I suppose you could use something like:
= DCount("[MyYesNoField]";"[TableName]"; "[MyYesNoField] = -1")
--
Kind regards
Noëlla


count yes or no said:
i put "=Sum(Abs([YourCheckBox])" in controlsource but it is not
working.How
can i do it right.plz help.
Click to expand...
Click to expand...
 

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

Newbie Help - IF Yes No Function 0
Reports for Yes/No Variables - Help! 3
How to count the numbers in a Word document? 0
Section and Page numbering 0
complex sort search and replace macro 2
basketball scoring 0
Report counting yes/no 2
Counting YES/NO in a Table with a Query 5

Top