I am currently working on the above report. The monthly budgets are contained in one table, the costs in another. If work from the budgets table to costs I can see all costs against a cost code that has a budget, but if costs are incurred against a cost code that doesn't have a budget this will be missed. I could work the other way from costs to budgets but the report wouldn't show costs codes that had a budget but where no costs had been incurred.
Please can someone advise on the best approach?