Please Help! Ref Article ID 210504

Tech-Archive recommends: Speed Up your PC by fixing your registry

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!
.

Relevant Pages

  • Re: type mismatch error 13 from set rstSource = ("RouteTable")
    ... Obviously you haven't encountered a problem when using DLookup() - put in a field or table that doesn't exist and the error is 'YOU CANCELED THE PREVIOUS ACTION' Oh that's REAL helpful! ... I was too wound up trying to figure out why English in the control panel was the problem. ...
    (microsoft.public.access.modulesdaovba)
  • Combo Box - After update...
    ... record source table of the form) ... DLookup? ... Brett ... Prev by Date: ...
    (microsoft.public.access.formscoding)
  • RE: Dlookup in expression
    ... > You need to add the field name you want to filter on, in the dlookup. ... >> I have an unbound object which looks up a date: ... Prev by Date: ...
    (microsoft.public.access.forms)
  • Re: Dlookup problem
    ... I don't think that DLookup comes into it..? ... HTH ... Tim F ... Prev by Date: ...
    (microsoft.public.access.modulesdaovba)
  • DLookup coding help!!!
    ... I've set up a main form "Companies" with the city field using a DLookUp ... I have tested the different parts of the expression, and the separate parts ... Prev by Date: ...
    (microsoft.public.access.formscoding)