Grand Total from Two Reports

[LadyIlsebet]

I have two reports, for inventory purposes, based off of crosstab
queries. Each report is based off of a different table, but also each
deal with replacement costs for inventory. The crosstabs are set up so
I can see what the total replacement costs for items are each year.

Now the boss wants a grand total of both of these reports. They do not
have all the same fields involved, aside from Asset Tag, and the Year
columns from the crosstab - aside from these two fields, very
different things need to be tracked for the inventory items, and the
boss will need to see all the information, not just the fields in
common.

How can I get a grand total cost for each year?

Thanks in Advance!
Amy