I work for a trucking company and we are attempting to move into the current century and go digital with our drivers time cards. We have installed electronic tablets into all the trucks this year (per government regulations) and were able to add a form through the tablet software which a driver can select either "start" or "end", enter their trip number and it fills in the driver's name, truck used, current odometer, and the date/time. These entries can be exported to a csv.
So I've created a table in Access that has the following fields:
Driver
Shift (Start or End)
TripNumber
TripDateTime
Tractor
Odometer
I have an append query which uploads the data from the csv file into Access exactly as it comes to us from the tablet software.
I have the data now I'm looking to get some reports run on it. I want to see the start of a trip, the end of a trip, and how many miles the driver traveled. I'm stuck. I know I need to query. I was thinking I need to somehow get the start and end in the same record, but I can't seem to figure out how to do that. Sometimes a driver misses putting in an ending entry or accidentally puts in two starting entries. Now that I have the data, I don't know how to manipulate it so it's usable. Any help is appreciated.