>I am trying to produce a ledger summary report. I have a lookup table that includes some descriptive text, a budget amount, and a budget code. I want to produce a table that is like this with a field for amount spent. The amount spent should come from a check table, linked on the budget code. But, those budget codes that have not been used don't show up. I need those to show though. What am I doing wrong?

You have to do an outer join.