As a further note, though, it is possible to do this through SQL. It requires some extra gymnastics, and may slow down your report. But it is possible.
SELECT OriginalQuery.*, ForOrder.DeliveryState
FROM OriginalQuery
JOIN (
SELECT DelMain.TruckID, DelMain.DeliveryState
FROM Delivery DelMain
JOIN (
SELECT TruckID, MAX(DeliveryDate) AS MaxDate
FROM Delivery
GROUP BY TruckID) DelSub
ON DelMain.TruckID = DelSub.TruckID
AND DelMain.DeliveryDate = DelSub.MaxDate) ForOrder
ON OriginalQuery.TruckID = ForOrder.TruckID
Obviously, you will have to modify that for your own values. But, hopefully that will give you an idea of the structure you need to follow. You can then sort on Delivery State.
IP Logged
