Commulated timeline (1 Viewer)

[RasmusElkjaer]

Hello

i have worked on a databse for warranty, and i want to know when the case was open, i alredý have that, but then i would like a history of when i change the status to closed, then it will tell me the closed date, but also that it was closed, then i mayby want to open it again, and the same thing should happen. something like this picture the be lowest part from excel i would like to use i for reference, so i can se how many we have closed this month, or open and so on anyone know how to do so? or can link me what to seach on?

Kind Regards Rasmus

 

[Gasman]

If you want to track something like that, then I expect you would want a status table?
That would hold at least
ID
Foreign Key from warranty table
Status
StatusDate

Then you can see the history.?

HTH