With adding a column in a table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Katherine - 27 Aug 2004 15:32 GMT

Is there a way to add the number of yes/no's in a yes/no
column that produces a check mark on yes - if so can you
please help me with how to do this. Thank you

Katherine

Reply to this Message

Allen Browne - 27 Aug 2004 15:47 GMT

To count the number of Yes records in a field named MyYesNo in a table named
MyTable, use:
= - DSum("MyYesNo", "MyTable")

Access stores Yes as -1, and No as 0.
Summing the field therefore gives the negative of the count.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> Is there a way to add the number of yes/no's in a yes/no
> column that produces a check mark on yes - if so can you
> please help me with how to do this. Thank you
>
> Katherine

Reply to this Message

Tim Ferguson - 27 Aug 2004 16:30 GMT

> Is there a way to add the number of yes/no's in a yes/no
> column that produces a check mark on yes

Or use the DCount function with a suitable criterion:

DCount("*", "MyTable", "MyYesNoField=TRUE")

Hope that helps

Tim F

Reply to this Message