If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Please Help! Ref Article ID 210504
While I found previous comments helpful, I still have an issue I can't
seem to figure out. Say I have a table with an "ID" field, an "In Date/Time" and "Out Date/Time". I want to calculate the elapsed time between events ("Out Time" of the previous event to the "In Time" of the next event). Everything works fine until I forget to add a record and need to add a record with times which fit between 2 previous records (Based on the In Time). The new record is entered as the last record in the table and the DLookUp is now finding the "Out Time" of the previous record in the table but not the previous event (Based on the "In Time" and "Out Time" fields). What I want is for the DLookUp to find the "Out Time" of the previous event based on the "In Time" and not the "ID" field for cases like this where a record may be entered later. Any help would be greatly appreciated! -- If you can read this thank a teacher... If your reading it in english, thank a veteran! |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
The pivot tables 101 article says to use the "Create List" comman. | cgnoland03 | New Users | 2 | January 15th, 2005 12:39 AM |
KB Article Q128813 ACC2: How to Create a Stopwatch Form | Milton | Using Forms | 0 | December 8th, 2004 03:47 AM |
Troubleshoot the SendObject method | Nikky_Pickles | General Discussion | 1 | August 30th, 2004 07:40 AM |
Microsoft Knowledge Base Article - 832285Microsoft Knowledge BaseArticle - 832285 | Alain | Setting up and Configuration | 3 | January 18th, 2004 06:54 PM |