adding columns

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

Katherine

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.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

message
news:[email protected]...
 
You have to use a query to do that. Access is a relational database, not a
spreadsheet, so use it relationally. Tables are for storing data. Queries,
forms, and reports are for doing calculations.
 
Back
Top