Creation of the Table

[TanTan412]

Creation of a query whenever the create a calendar and if end date match with the calendar date it subtract the number of item however if that item is 14 days old it will add

for example

date-----------lost----(Items)-Added-(Items) (Start Date) (End Date)------ Total
10/30/2024---2------A, B---- 3-------C,D, E --10/15/2024--10/30/2024 ---- 5
10/29/2024---0---------------2 -------G,H--- 10/14/2024 ------------------4