formula to count checked boxes in a table.

E

emmy128

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
 
T

Tonín

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

or

=-Sum([YourCheckBox])


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

:)


Tonín
 
E

emmy128

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...
 
T

Tonín

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...
 
Top