form calculations with yes/no fields for totals "yes" responses per record

I am working on a form (that is linked to a table) that contains a series of yes/no fields (about 12-15) in which I would like to insert a calculation at the bottom that will total the number of "yes" responses per record.

I am currently trying to use the domain count function and have written :

=DCount("[Field_one]","[Table_name]","[Field_one] = True"+"[Field_two]","[Table_name]","[Field_two] = True"+"[Field_three]","[Table_name]","[Field_three] = True"+"[Field_four]","[Table_name]","[Field_four] = True")

etc. for each of the 12-15 fields.

The error message I'm receiving states "The expression you entered has a function containing the wrong number of arguments"

I'm also wondering if the code I've written would attempt to give me a total number of "yes" responses for that field in the entire table, as opposed to adding all the "yes" responses per record.

Help!

Hi all,

It's me again. I just figured it out on my own (isn't that how it always happens when we post a question?)

As it turns out, I was making this much more difficult than need be. For adding "yes" responses in a series of yes/no fields for each record, I only needed to enter the following in the textbox (just in case anyone else is curious):

=[Field_one]+[Field_two]+[Field_three]+[Field_four] etc...

Easy!