Search results

I got lost and that code was confusing me, it is based on the link you sent me. I decided to start using "last" but that wasn't working, it was just giving me random previous data. So I started to use DMax() and pulling the data that way and it seems to be working better, I am just trying to...

pbaldy- I am having trouble with his code here is what I have so far: .DriverID, [All Activity].TransDate, [All Activity].Odometer, (SELECT Top 1 Dupe.Odometer FROM [All Activity] AS Dupe WHERE Dupe.DriverID = [All Activity].DriverID AND...

Hello-- I am working on a database for a transportation company. They have an issue with their trucks being down and out of service which is where my problem begins. I need to take the MaxOdometer from a trucks previous day in operation (PreviousMaxOdometer) and subtract it from todays...