View Single Post
  #2  
Old April 10th, 2005, 01:50 AM
Randy Harris
external usenet poster
 
Posts: n/a
Default

"Telobamipada" wrote in message
...
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!


It's difficult to understand what you are trying to do. Suggest you post
some sample data to provide a clearer explanation.

BTW - your tag line is a nice sentiment. Given its content, however, you
should correct the grammatical error in it.

(my 2 cents worth for both suggestions)