Hi there,
I have 2 tables, an employee table and an absence table, which is a one to many relationship. I want to count the amount of dates for each employee and have done so by using the following on a report.
=Count([Date])
(Date being on the absence table, so each absence will be counted)
This works and each employee has a count next to there name depending on the amount of unauthorised days off each employee has. The only problem is that I only want to display the employees who have 4 or more days off.
How change I change "=Count([Date])" to incorporate this, like: If ([date]) =>4 then count (something along those lines but that wont work!)?
Thank you