Hi,

   Thanks for your help in advance.

   I am trying to do some date calculations. Here is some sample data:

'============================================
tblSecLog.
AppID AppName EventNo Date Time Event User
26 MSACCESS.EXE 5644 11/29/2004 3:28:05 PM Close mmcdonal
27 MSACCESS.EXE 5644 11/29/2004 3:27:57 PM Open mmcdonal
28 MSACCESS.EXE 61372 11/30/2004 7:43:44 AM Close mmcdonal
29 MSACCESS.EXE 61372 11/30/2004 7:43:31 AM Open mmcdonal
'============================================

You can see from this that I am tracking the opening of an application, and the closing of an application. The application has a single event number, so I know that each is the same instance of Access opening and then closing. I know the time the app opened, and the time the app closed.

I need to calculate, for many instances of Access for example (each with its own unique event number), how long access was open in a particular day. In this case, it was open for 8 seconds on the 29th, and 13 seconds on the 30th.

Perhaps this needs to be a query, so I will post this in Access, but I will monitor both for posts, and update the other with solutions.

Thanks,



mmcdonal

__________________
mmcdonal

Look it up at: http://wrox.books24x7.com

Hi, thanks everyone. I already got posts and solved the problem under the Database>Access forum, post name "Query Help."


mmcdonal