To build this query, follow the next steps:
Click Access Button
then click HR Admin.
Click Queries then click on + icon.
Select Absences from the one-column list on the left. Then select the following from the list on the right:
Sick Updated On
Sick Updated By
Deleted Sick Record (Yes/No).
Filter on Equals: Yes
Sick Deleted On.
Sick Deleted By
Click Next and add any remaining appropriate details.
Click Next and view the query results.