Time tracking problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am developing an employee log-in database. Currently the employee types in
their id and pw and they are logged in or out depending on previous status.

One record has the log-in time and log-out time.

Now the client would like a form where they can check/approve/manipulate the
data as necessary. My problem is the client wants to see a record for each
working day whether the employee logged in or not. This is so that sick
time, vacation time etc can be recorded and the employee paid as necessary.

I can't come up with an idea that doens't seem awkward.

Any ideas?
Thanks
 
Hey, Alienz.

If you populate a Days table, you could join it with an outer join such that
a record appeared for each Day regardless of whether a record exists in the
log-in table.

Hope that helps.
Sprinks
 
This sounds like a good idea but I'm not sure how to make it work since you
would have a full date/time field trying to match to a 'monday' or datepart.
 
Back
Top