Form Table with Historical Data

Nice day

Every day I receive a .txt file with computers that need to be repaired. As relevant data is the date of entry, date of the report and ID_equipo. New revenue can be added every day, but if a computer is repaired, it is no longer present in the listing.

I would like to make a basis that contains the history of these records, a basis which we will call, for example, "historic". Based on N-day, "historic" will contain all N-day records; on day N+1, historical will contain N records and new N+1 records, while the historical N+2 day will contain N records, new N+1 records and new N+2 records, and so on...

The first drawback I encounter: What I managed to do is add to "historic" the new records of the day I process, but I lose the records of the previous days. That is, if I process on the N+2 day, I do not know the records of day N+1. I used to append consultation, but clearly that's not the way, or I'm missing some previous step.

The second drawback: I want to record the repair date of the equipment. Conceptually, if ID_equipo was present on day N and the N+1 day is not present, then it was repaired and report date would be the repair date. I'll face this by combining left external query, between "historical" and the daily basis, and where there's error, it's the ones I need to record. I managed to take those records to a "repaired" table by assigning the report day as a repaired day, but when processing the N+2 day, all repaired on day N+1 would go on to have a repair date as N+2.

Can you help me resolve these issues?

From now on, thank you very much for your time