Perhaps it makes it clearer if I tell you (in summary) that the database
itself lists all the Income and expenses of my hubby's one-man gardening
business over the last 3 years.
Each year, I archive the previous year's data into an ArchiveTable in the
database.
I've used a Union Query to combine the expend
This Expenditure table contains ItemID which links to TblItems which
contains ItemID and Item. Item contains records like
Fuel, Vehicle Repairs, Stationary, Tools, Materials
To get the fuel expenditure, I filter ItemID in TblExpenditure so that only
the expenses on fuel are showing.
That is the only Item I want to show in my chart. I want to compare monthly
costs from one year to another.

I suppose I could solve this by adding a field to a query based on
TblExpenditure that says :

FuelExpense:IIF([ItemID] =6, [Expend], 0)

so that only the fuel expenditures are totalled while the other records will
contain 0.

I could use this field in my Crosstab Values section to get the total spent
on fuel for any  month in the Expenditure table for that year.

But even this would not work if NO expenditure was made in any one month
(winter can be very lean in the gardening business!)

I was expecting NZ to work in the crosstab too, but it didn't :(

Evi

I'm terrible with charts, but it should(?) be
straightforward once the query is properly designed.

I had the row/columns mixed up so now I think you will need
the 12 row table and the Left Join.  The Nz or IIf should
then work.