I'm working in an access database with the following fields (and others):
Asset; Asset_Date; Start_Date; Start_Time; Office_Stop.
Asset is a # field, Asset_Date is text; Start_Date is Date/Time; Start_Time is Date/Time; and Office_Stop is # (1 or 0).
Asset numbers are unique vehicle identifiers and all of the data are from GPS software. Using the GPS data and ArcGIS, I added the binary "Office_Stop" so I could tell whether each point was an "Office_Stop" or not.
I would like to know where each truck started (Office_Start = 1 or 0).
Logically, the start would be where the truck stopped last. I know I can export to excel, do a (B2=A1) type formula and move on. The problem is I have to import new data on a regular basis and I want to avoid multiple excel files and imports/exports in Access - I have too many working files as it is.
Is there a way to have access query the "previous record" for each asset?
Ps. I can read some SQL, but I'm really not great writing it.