Q: I own a company that requires my employees to review sales that were generated by telemarkeing rooms. A file is sent to us daily that is imported into our database. We have ran into a problem where our agents could be passing sales through as good and not really reviewing them. We are looking for a way to track when they started reviewing the the record (IN ACCESS), and when they stopped reviewing the record. At this point we could build a query that will show us anything that is reviewed under 1min or so. Can you pleaser advise? > Christopher

A: Good question, Christopher.

This wouldn't be too hard. I would create a form where the user can only see one record at a time (turn off the navigation buttons and record selectors and open this form from another form that has a list of all of the records they need to review.

Make two fields (StartTime, EndTime) and put them on the form, but keep them invisible (Visible property set to No).

Now, in the OnLoad event of the form, set the StartTime=Now() and in the OnUnLoad event, set EndTime=Now(). Then you can make your query to see the difference in times.