Choose record with closest time

[StephHansen]

I have two tables that do not have a common id to link them. I am trying to create a report to show how long it takes between when a truck arrives and when the package it delivered is processed.

Table 1: TruckHistory shows when a truck arrives
Table 2: PackageHistory details what happens when a package is received

TruckHistory.TruckArrivalTime shows when a truck arrived
PackageHistory.startTime shows when the package begins processing

I need to find the max time of truck arrival that does not exceed the start of the package processing.
similar to
Max(truck.truckarrivaltime)<=packageHistory.startTime

How would I do this within my report?

Stephanie

 

[Ngolem]

I have two tables that do not have a common id to link them. I am trying to create a report to show how long it takes between when a truck arrives and when the package it delivered is processed.

Table 1: TruckHistory shows when a truck arrives
Table 2: PackageHistory details what happens when a package is received



Question: How do you know you have the correct truck for the package?? or is this only a one-truck company?

Jim Broadbent

The quality of the answer is directly proportional to the quality of the problem statement!