SQL Table refresh

[adbhidas72]

Hello Community,

 need your help on this ( i am not able to attach files so pasting a sample of table)
I have a table as per the below structure

Run Date	Region	Manager	supplier	part	spend
10-Mar-23	Region3	Manager3	Suppr2	Part3	18891
10-Mar-23	Region1	Manager1	Suppr2	Part3	10824
10-Mar-23	Region3	Manager2	Suppr3	Part2	14979
10-Mar-23	Region3	Manager2	Suppr1	Part3	15868
10-Mar-23	Region1	Manager2	Suppr3	Part3	15111
10-Mar-23	Region1	Manager2	Suppr1	Part2	19506

my organization does not grant create table access on the server so workaround is to dump the above table into Access DB which i will use to create reports in Power BI.

The ask here is the owner of this table will refresh spend values for the existing dataset without altering the table structure and  append data only in case a new region or a new manager or a new supplier has sent the data every before fiscal month run.

the april run month table is now like this(Red ones are the new data received)

Run Date	Region	Manager	supplier	part	spend
10-Apr-23	Region3	Manager3	Suppr2	Part3	77036
10-Apr-23	Region1	Manager1	Suppr2	Part3	366771
10-Apr-23	Region3	Manager2	Suppr3	Part2	100775
10-Apr-23	Region3	Manager2	Suppr1	Part3	434291
10-Apr-23	Region1	Manager2	Suppr3	Part3	169688
10-Apr-23	Region1	Manager2	Suppr1	Part2	75593
10-Apr-23	Region 2	Manager4	Suppr1	Part2	340684
10-Apr-23	Region 2	Manager4	Suppr4	Part4	253959
10-Apr-23	Region 2	Manager1	Suppr4	part1	341101
10-Apr-23	Region 4	Manager2	Suppr2	Part5	28213
10-Apr-23	Region 4	Manager3	Suppr3	part1	42718

what i need is there should be some way to keep the old data table in access and a new column/table is added as per run date so that i can substract values from previous run to current run and check which region > manager> supplier> part has shown a high variance.