Time tracking problem

[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

 

[Guest]

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

 

[Guest]

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.