Thanks for the information - will work with the datediff function as that will help. However, the main problem that I am experiencing is the best way to structure the data. I would like to leave all the data in a table and then access it, calculate on it, etc, through queries (as opposed to code) to make things easiest. The question is, how to structure that table.

For example, is it best to just have have a tblClockTime that gets...

Been searching the web and various forums and can not find the answer that I need. Developing an application using MS Access 2000 and I need to include a time clock function. I have tried several different ways to store and track the data, but extracting the information for later in an easy way is the difficulty.

For example, I have 4 employees. They can clock in or clock out and it records the date/time of that action. So, in...