Appending 3 tables to 1

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have this huge dilemna,

i have 3 tables that has 5 columns each. the columns are
Date, location, balance, interest and total.
Now, i need to make this total table
that will have Date, Column, total of table a, total of table b, total of
table c
and the last column will be((able a + table b) - table c) for grand total.
I want it like if table a, b, c has location 7801, then i should see all the
totals in one line. Im getting

date | loc | Table A total | Table B Total | Table C Total
11-5 7801 100
11-5 7801 200
11-5 7801 200

I would just like to see

date | loc | Table A total | Table B Total | Table C Total
11-5 7801 100 200 200

i would just like to group it
I also need it that if for that date, there was only a record in table c, i
need it to be

11-5 7801 200

I'm not only looking for the date and location to be equal, just the date, i
like the location to be grouped. please help
 
You need to change your design slightly and realize a simpler and more
effective application:

The four tables you're considering should be a single table with a
field that stores a value indicating which of the current tables is
being referenced. That is, the current tables are exactly the same
table except for some characteristic. Name that characteristic as a
field in your new, combined table.

Your totals issues become mostly a matter of filtering on the value in
the new field.

HTH
 
Back
Top