Hello
I have data from a table that looks like this:
I would like to run a query to add two more fields:
NewField1 = [PrevHmKm] which is the next highest value from [CurHmKm] for the same [PlantNo]
NewField2 = [WorkHr] which is [CurHmKm] - [PrevHmKm]
The end result should be a run query that look like this:
How do I do this?