formula to count checked boxes in a table.

[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

 

[Tonín]

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

or

=-Sum([YourCheckBox])


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




Tonín

 

[Guest]

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

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

or

=-Sum([YourCheckBox])


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




Tonín

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

 

[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?

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

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

or

=-Sum([YourCheckBox])


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




Tonín

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