A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Please Help! Ref Article ID 210504



 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old April 8th, 2005, 07:01 PM
Telobamipada
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 12:26 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.