Labor Head Query Question

Good afternoon,

Each Labor Head row houses the clock in, lunch out, lunch in and clock out in separate columns. Is there a relatively easy to build a BAQ that would break this out row by row showing a different one of the four clockins sequentially? For example it could look like this:

Emp01 4/9 8:00AM
Emp01 4/9 12:00PM
Emp01 4/9 12:30PM
Emp01 4/9 5:00PM

Union join to itself 4 times display different field in each subquery. #Expensive

1 Like

Thank you! I am going to try this out tomorrow.