Hello,
Can someone please tell me what criteria I need to enter to omit expired data from the report?
Example: When an employee is late, leaves early, or is absent they receive either a .5 or 1 point. This point cancels after 1 year. Currently the report captures all of the information and I even have a total value for the points.
I need to be able and run this report that only shows points that have not expired, since the ones that have are irrelevant for disciplinary tracking.
I have included a snapshot of my query.
Thank you for your assistance!
Can someone please tell me what criteria I need to enter to omit expired data from the report?
Example: When an employee is late, leaves early, or is absent they receive either a .5 or 1 point. This point cancels after 1 year. Currently the report captures all of the information and I even have a total value for the points.
I need to be able and run this report that only shows points that have not expired, since the ones that have are irrelevant for disciplinary tracking.
I have included a snapshot of my query.
Thank you for your assistance!