Complex Lookup?

[murphyB]

Hi all.

I'm not terribly proficient with Access and I'm looking for a solution to the following problem. Any help you can provide would be wicked awesome.

I have created a budget database (this isn't the complete db, just everything relevant to my question:

Clean Budget
-ID (PK)
-Date


-Amount
-Project

Projects
-ProjectID (PK, related to "Project" in Clean Budget table)
-ProjectName
-BudgetAmt

So, the Clean Budget data rows are imported from monthly Excel budget reports. What I want to do is create something (a report) that will display each project, the budgeted amount, and the totals from all records in Clean Budget associated with each project. A twist on this is that while I can make a query that does that, it won't show any projects where there's no spending.

I've tried creating a field in the Projects table called "ActualAmt" but I don't know how to make that populate dynamically from matching rows in Clean Budget. I feel like this would be the easiest if possible because I can then just create a query and report directly from the Projects table.

Again, if you can shine any light on this for me, I would really appreciate it.

Thanks!
-MurphyB

[murphyB]

Actually, no response needed. I found that I could manage this by creating an outer join in the two tables.