Sum data from multiple tables

[dm23]

I have a lot of tables that represent line items on a report. The tables are set up like this:
Month1 Month2
Location 1
Location 2
I'm wanting to sum the data for several months for each location. If possible, I want to run a query that will sum 6 months of data for 5 or 6 tables to that it will look something like this:
Sum6MonthsTable1 Sum6MonthsTable2
Location 1


Location 2

Is there a good way to do this? Thanks in advance for your help!

[ssanfu]

From what you have posted, it would be very difficult.

I would advise stopping what you are doing and normalize your table structure. It sounds like you are "committing spreadsheet". Instead of multiple tables with months, there should be one table with a field for the month/year (or a date field).

Search for normalization in this forum. I had a list of good sites, but I can't find it right now....