Check last status and if different add new row

[icordeiro]

I have a table on access with allocated processes to people and every week I get an excel file with the last status of those processes.

I copy the records from excel to another table on access and I run a query that checks which processes from the weekly status I already have allocated and updates its status to the latest one.

I would like to track an intermediate status (let's say B). So if there is a process for which the latest status is 'B' I would like to run a query that adds a new line to my table where I keep all the allocated processes with the same process ID.

So I would have two lines per process if they change to status 'B'.

Is this possible?

 

[Micron]

Not sure I follow. Why not just update the existing record status field to "B" instead of duplicating records?
Your idea seems to violate normalization rules.