TOTAL UNLINKED TABLE

[Ananth]

I have 12 tables each representing 1 month. this table has all details for
bank payments in the month.for some reasons we are not merging the tables,
though structure is same. the tables have a filed titled NET PAYMENT. All
these tables sit in a an Access DB - Payments2007.mdb.

My intrest lies in running a single query where all these tables are called
& only the NET Payments Field summation result should showup: The query
output should be as under :

Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total


Ananth

 

[Douglas J. Steele]

You REALLY should combine them into a single table!

While you're waiting for the tables to be corrected, though, you can write a
UNION query that normalizes the data for you:

SELECT Field1, Field2, [NET PAYMENT], "Jan" As WhichMonth
FROM JanuaryTable
UNION
SELECT Field1, Field2, [NET PAYMENT], "Feb" As WhichMonth
FROM FebruaryTable

....

UNION
SELECT Field1, Field2, [NET PAYMENT], "Dec" As WhichMonth
FROM DecemberTable

You can then use that query as the basis for a cross-table query that will
return the data in the format you want.