One form Checkout puts NOW() in the checkout column of the Events table. For return time there is a separate form putting the NOW() in a column Return in the events table. Those separate forms are selected through a main menu.
So the short answer is that it is handled in separate columns by separate forms so I can compare the intervening time.







The input device the person checking...

I am setting up a database in Access 2007 to track equipment that is checked out and returned everyday several times a day. I have the checkout and return times working, but I need the Returns form which only has a text (to enter the equipment ID) to look up the last matching equipment ID record with no return time and insert the NOW() in that record.
The object here is to quickly allow a clerk to simply scan in and out equipment without any...