I am developing a very simple time clock program using a web interface and an Access database. All it does is log a user and the server variables time and date into the database. My question is, once I have this information in Access, how can I total it. Remember that each user will have two clock ins and clock outs for any given day. I think I need a way to subtract the in from the out twice a day, but what happens then if someone forgets to clock in or out? <BR><BR>&#060;a href="http://www.nathank.com/screenshot.gif"&#062;Screen shot of table layout&#060;/a&#062;