Okay, I am trying to build a report that will pull info from a database table. The table is populated by a form with a specific PN (pulled from another table) and 28 additional fields (formatted as combo boxes with yes/no/na options)
I want ant the report to be filtered by the PN and provide the percentage of each possible answer.
Something like:
PN: xxxxxxx
question. Yes. No. N/A
Question 1: 50%. 30%. 20%
etc
etc
I think I will have to build a query first then base a report off of it.
I just started working with access on Monday so I am very new to this! Please be kind!