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!!


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.