Hello,
I have a table in my database that contains is a list of all the work record dates for each employee, along with a "type", which is either "ABS" (absence) or "work". For example an extract of my table looks like this:
Clock number Date Type
1 1/1/20...