Budget vs Actual

[chaos]

Trying to create a DB that compares budget values to actual costs. 4 Tables
Project
ProjectID
ProjectName



CostCode
CostCode
CostCodeDesc

Budget
BudgetID
Project
CostCode
Amount

Expense
ExpenseID
Project
CostCode
Amount

My problem is each job can have a budget cost code with multiple entries, an expense cost code with multiple entries, and each budget cost code my not have a corresponding expense, or each expense my not have a corresponding budget item. So, when i try to print a report if my data looks like:

Job1
Budget: CC1, $500
Expense: CC1, $100
CC1, $50

My Report Looks Like
Job1
CC1
Budget Expense
500 100
500 50

I am attemping to list the budget and expense amounts for each cost code weather it's 1 or 10 for each.

I hope this makes sense
Thanks

[alansidman]

I think that you need to set up an aggregate query grouped on the Budget Code and summed on the Budget Field and Expense Field.

In a separate query, use the first query as your record source and create an Expression for the variance.

Alan