I'm working on the attached database, which is to be used to track employee audits. Employees are reviewed based on four criteria (Complete, Notes Correct, Update, & Other) & are scored either Yes (criteria met) or No (not met). They must get at least 3 Yesses to pass, otherwise that case fails. And they must pass at least 80% of the cases to pass the audit. I think I have everything properly set up. Now I need to create a report to filter those audits that did not pass. I believe I need to create a query in order to make a report showing all the failing audits. For the database I uploaded, the report should list Employee 1 as failing; Employee 2 and Employee 4 as passing. Can someone point me in the right direction?