Posted 27 July 2010 - 09:24 AM
I have an Access 2003 Service Pack 3 database. It has a form for call logging. I need to be able to find out how long the call is being logged. There's a combo box called Status that is set to one of two values, either Active or Closed. I need to have the elapsed time value from when the Status field goes from Active to Closed. My OS is Windows XP Professional SP2. Everything I've found on elapsed time requires two time fields, which I don't have. Any ideas would be greatly appreciated! Thanks!