Crosstab Query with data from two tables

[KRossVD]

I am relatively new at working with queries. I have two tables, one with realized expenses fro certain months and another with budgeted items for certain months. I am trying to create a query which will take all the expenses, put them into the categories I have them labeled under and sum for each category for each individual month. I can get this far (although the dates aren't in order) but I also need to attach the budget for the last months expenses as the last column in the query table and this I have no idea how to do. Any help would be much appreciated.

 

[ranman256]

You could make a query for each table (tExp, & tBudg) that sum the fields needed, but add a month column (say [YrMo] so both queries can be joined (like: format([ItemDate],"yyyy-mm") as "YrMo" )
Join the 2 queries on like fields and [YrMo], now expenses and budget come together on 1 line/month.

'sorry I missed the crosstab ref....note You wouldnt join if you want Xtabs to be month, Xpense, Budget., it would be a UNION query.
select * from qsExps
union
select * from qsBudget

Then run cross tab on that qry...qnExp&Buget