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 this happen?
Forum Discussion
- If you have a relationship between Employees and Audits you can make a summary field on the left side of the relationship to count the # of audits subject to a filter that the Audit date was during the current month. I would also do a similar summary field to count the # of Audits last month to see who got missed.
- 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.
- I think this will do what management is looking for. Thank you.
