formula to count checked boxes in a table.

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

Guest

Hi,

Im wondering what formula i would use to count the number of checked boxes
in a table using a querie??

ive tried just "count" without criteria, and it counts the total number of
rows in the column, not just the checked boxes. When i specify the criteria
as =count("true"), it doesnt work.......help!!!!

i know what i want my formula to say: "count the number of checked boxes in
this column", but i dont know how to apply it to a formula.

please help!!!

Cheers
 
SELECT -Sum([YourCheckBox]) AS QtyChecked
FROM YourTable;

or

=-Sum([YourCheckBox])


.... depending on what you are intending to do

:-)


Tonín
 
i tried to use that formula as the criteria in my querie, and it did not
work. any other ideas????

Tonín said:
SELECT -Sum([YourCheckBox]) AS QtyChecked
FROM YourTable;

or

=-Sum([YourCheckBox])


.... depending on what you are intending to do

:-)


Tonín


emmy128 said:
Hi,

Im wondering what formula i would use to count the number of checked boxes
in a table using a querie??

ive tried just "count" without criteria, and it counts the total number of
rows in the column, not just the checked boxes. When i specify the criteria
as =count("true"), it doesnt work.......help!!!!

i know what i want my formula to say: "count the number of checked boxes in
this column", but i dont know how to apply it to a formula.

please help!!!

Cheers
Click to expand...
Click to expand...
 
This is a *complete* query:
SELECT -Sum([YourCheckBox]) AS QtyChecked FROM YourTable;
You should change [YourCheckBox] and [YourTable] into your actual names.

And this is an *expression*:
QtyChecked: -Sum([YourCheckBox])
for a Totals query. (select group by: Expression)

And this is to use in a TextBox (in a form):
=-Sum([YourCheckBox])

Can you pls post your query to see what might be wrong?


emmy128 said:
i tried to use that formula as the criteria in my querie, and it did not
work. any other ideas????

Tonín said:
SELECT -Sum([YourCheckBox]) AS QtyChecked
FROM YourTable;

or

=-Sum([YourCheckBox])


.... depending on what you are intending to do

:-)


Tonín


emmy128 said:
Hi,

Im wondering what formula i would use to count the number of checked boxes
in a table using a querie??

ive tried just "count" without criteria, and it counts the total number of
rows in the column, not just the checked boxes. When i specify the criteria
as =count("true"), it doesnt work.......help!!!!

i know what i want my formula to say: "count the number of checked
Click to expand...
boxes
in
this column", but i dont know how to apply it to a formula.

please help!!!

Cheers
Click to expand...
Click to expand...
Click to expand...
 
Back
Top