A
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
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