So I've been searching for the answer to my problem with no luck. I will make a simple version of what I need to do to make this question easier to ask.
I have 2 tables,
table 1 is [Employees] with Fields [Name] and [Passcode]
table 2 is [Clockedhours] with fields [Employee] , [Date of Work]...