Skip to main content
Question

List all from another table

  • Jun 28, 2019 8:50 PM UTC
  • 0 replies
  • 61 views

Forum|alt.badge.img+7
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?
This topic has been closed for replies.

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.

Forum|alt.badge.img+14
  • Qrew Corporal
  • Jun 28, 2019 8:55 PM UTC
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.

Forum|alt.badge.img+7
  • Author
  • Qrew Corporal
  • Jun 28, 2019 9:22 PM UTC
I think this will do what management is looking for. Thank you.