I have a master table including ID, Date of report, Date of Installation. I need to write a formula in Access that if the ID of each row is equal to the above row then insert the Date of report of the above row & if ID is <> the above row insert the Installation date of the current row. I need to compare each row with the above row, not the entire table!
I used: Last installation date: IIf([From where (Bus Number)]=[From where (Bus Number)],[Date of report],[Installation date]) --> giving the Date of report of the current row!!