With adding a column in a table

  • Thread starter Thread starter Katherine
  • Start date Start date
K

Katherine

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
 
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.
 
Is there a way to add the number of yes/no's in a yes/no
column that produces a check mark on yes
Click to expand...

Or use the DCount function with a suitable criterion:

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

Hope that helps


Tim F
 
Back
Top