Please excuse me - I need to re ask this question = I want
the addition to go into the table directly under six
seperate columns so that I may total them, but I cannot
figure out how to get the formula into the columns
directly under the information - I want it to act the same
as the add function in excel  - adding the number of X's
that appear above it.  However the column wont let me add
a function - only a check




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.