I have a database which gathers and stores the odometer readings of our company vehicles every month. I have built a simple report with columns for Vehicle Number, Employee Number, Employee Name, Month, and Odometer Reading. My boss wants a field for each employee which compares the records for the last two months and displays the difference (i.e. the number of kilometers travelled in that month)
From my research, I suspect that I would somehow need to join two rows to accomplish this calculation, but I simply cannot figure out how to do this. I should add that I have zero programming skills. I know how to add code in VBA, but that's about it.
Any assistance would be greatly appreciated!
From my research, I suspect that I would somehow need to join two rows to accomplish this calculation, but I simply cannot figure out how to do this. I should add that I have zero programming skills. I know how to add code in VBA, but that's about it.
Any assistance would be greatly appreciated!
