1 Reply Latest reply on Jul 23, 2012 10:25 AM by philmodjunk

    Timing Calculation Issue

    JonathanKennedy

      Title

      Timing Calculation Issue

      Post

      I have just started building a database again(built one for a former company in 2006) and I am having a little trouble getting back into the swing of things. So any insight would be greatly appreciated. 

      I will apoligize in advance for miss use of terms so please bare with me...

      I am building a tracking form in the field of transportation. 

      This what I would like to be able to do: 

      I would like to be able to figure out total time elapsed from departure to arrival in two sperated records. 

      Example: Record 1 

      Item A depart at 12:00PM

      Records 2-6 are created for Items B-F 

      All which depart between say 12:10PM and 1:00PM at various times

      Record 7 is created when Item 1 Returns at 1:30PM

      I would like my Roundtrip Field to automatically calculate the time between when Item A (in record 1) left and when Item A returned in record 7. 

      I hope this makes sense. If not I will try to explain it better. 

      I have already be able to figure out TimeBetween Item A departure and Item B arrival by using This equation: TimeBetween: ArrivalTimeStamp - GetNthRecord ( DepartureTimeStamp ; Get ( RecordNumber ) - 1 )

       

      Thanks

        • 1. Re: Timing Calculation Issue
          philmodjunk

          Do you have a field that identifies all of these records as being part of one specific delivery route? Say you have 50 different records, how do you know that these 7 make up a specific trip and the other 43 do not?

          If we have such a value, then a relationship can be set up such that the first and last records can be used to compute the elapsed time and there are also ways to do this with a found set of these seven records.