Dividing a month-department budget into day-department budget

Hi , I have to divide a table that Financial Department gave to me , it is table with three columns: DEPT MONTH BUDGET A 1 50.000€ B 2 70.000€ C 3 30.000€ D 4 20.000€ I have to cross it with the DATE table in order to make a daily table: DEPT MONTH DAY BUDGET A 1 1 (50.000/31 days of JAN) A 1 2 (50.000/31 days of JAN) A 1 3 (50.000/31 days of JAN) A 1 4 (50.000/31 days of JAN) .... And so on ... Anyone knows how to convert or divide a table into a daily table? Thanks in advance my friends.