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.
can i do it right.plz help.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
BruceM
Control Source of what? In what way is it not working? What are you trying
to sum?
to sum?
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.
a time. Perhaps if you can explain WHAT you want to do, we can help with the
HOW to do it.
K
KARL DEWEY
Also you have two opening but only one closing parenthesis.
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")
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.
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.