Help with calculations
Being new to FM, I am trying to design a report for the transport industry.
I have a vehicle come in for inspection = Date In
Vehicle leaves inspection = Date out.
Date out - Date in = Days in workshop
2. I need a calculation for the number of days between Date Out and the next Date In
Date In - last Date Out this needs to give me the period in days between inspections
It would also be good to show the number of days 42 until next inspection date
3. When the vehicle comes in I also need to record the odometer.
I need to calculate Odometer In - Last Odometer In to give total miles travelled
Thank you in anticipation