List all from another table
I have two tables - Employees and Audits. Every employee must have an audit every month. I can run a report on the audits table that shows who has had an audit but not who hasn't. How would I make thi...
Forum Discussion
Unless every Employee has an Audit record for each month; which you can then interrogate for population versus non-population; you could need to get this information from your Employees table. You can do this by building a summary field that counts the # of Audits for the current Month. Then you can find Employees have a 0 count.