I've got one table with Budget and one with Acutals and have made up a P&L statement. What's the easiest way to substitute actuals with budget values when the actuals are missing to have a full year P&L statement before the end of the year?
Can you show us a screenshot of your tables and their relationships ?
Do you have a Calendar table that is linked to both the budget table and the actuals table.
If so you can link to a record in budget and a matching record in actuals and create a calculated colum in the actuals table that just substitutes the related value from the budget table when actuals is missing.