Question
List all from another table
+7I 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.
+12Unless 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.
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.