Running into a little problem. I'm creating a database to track quality audits my department does for various processes around our operation. There are 12 audits that we perform, most of which share fields, such as dirty, wrong status, and damaged container. The data that goes into the fields is a 1 if the answer to the question on the form is Yes (Failed Audit), and 0 if it's a no (passed Audit).

The way I have the table structured is each record has a field for every audit question, regardless if it applies to that specific audit or not. The forms for inputting data only have fields that apply to the audit, so the rest of the fields are left blank.

I'd like to have a field that will sum up all the audits represented in the record that apply to a pass/fail of an audit. This information will go on a report that shows how many audits were completed and how many defects there were. Is there a way to do this in the Audits table?

Sorry to say you can't have formula fields in a Table, what you would need to do is create a form or query to look at the data you need and sum or count accordingly.