Hey People, I am trying to write this VBA script in Access, perferable in a table if possible otherwise a form. I want to keep track of people who log onto a system by DateIn, TimeIN, DateOut, TimeOut. Then I will have a Total that will accumulate the the total number of hours logged onto the system. I am running into problems when someone logs on like this 2/15/00 1:00AM - 2/17/00 3:00AM. Instead of getting 50 hrs I get two hrs in the total Hours. I would appreciate any help, thanx in advance
