allocated vs unallocated budget

[kms]

i'm trying to build a query that will compare my allocated expenses to the
unallocated expenditures. in the first column I would like all of the
categories for the budget to show regardless if funds have been allocated or
not. column 2 I would like the budgeted totals column 3 allocated funds if
there isn't any funds allocated i want the field to show zero and the 4
column should be the difference between the budgeted and allocated funds.
i've tried different queries but I can't seem to get the layout i need. Oh
to further complicate things each budget is for a different month so what to
do with the month id needs to be considered as well. Thanks for any help

 

[S.Clark]

Without knowing the table structure(s), an answer isn't possible.

My guess is that there are at least three tables involved, or at least
should be. Given this, you will probably need to use multiple action queries
to build the result table that you need.