Report - Summing up Yes/No Datatype

[svtguy02]

Hey Guys,

I've got a DB that I've pretty much completed. It's a VERY basic DB with about 10 YES/NO fields.

I've got a relationship between 2 tables.

Table1: Contacts
Table2: Handoff Form

Contacts just has peoples information and that is attached to the handoff form.

As you're in the handoff form you select a contact then select YES/NO for the appropriate fields below.

What I want to do is be able to create a report based on contact.

I pull up the contact and get a report and do a total summary of each field that gives a number of how many yes' there are, how many no's and how many total records associated to that contact there are.

Any questions please let me know.... the DB is attached in the zip file