How to count multiple text boxes

[Brian62]

I have a report where I am trying to count all the text boxes which comprises of about 8o. I want to separate them by Yes, No and N/A. I tried a few different options and none have worked in Control Source.

Example1: =Count(IIf([RDStudyAuditSectionA.Doc #12-5]+[RDStudyAuditSectionA.Email Corrospondence]+[RDStudyAuditSectionA.Doc #2]="Yes",0))

Example2=Count(IIf([Doc #12-5]+[Email Corrospondence]+[Doc #2]="Yes",0))

Example3=Count(IIf([Doc #12-5],[Email Corrospondence],[Doc #2]="Yes",0))

The formula is set in the report footer. The information is coming from a query with 8 different tables linked to one query which the Report operates off of.

I have tried it on the query side but I can't figure it out there as well.

Thanks!

 

[Brian62]

I have attached part of the DB so you understand what I am trying to do. If you look at the column in the middle that is what I am trying to count for each Yes, No and N/A.

I like to be able to do a percentage of the Yes + N/A - No if that is possible. The "Yes" and "N/A" would total 100% - the Total of "No" to give me the correct percentage across the board for all names. I know that there is a lot of fields but I am trying to get away from using Excel. Most of my work is done through Access now I am trying to finish this one.