Adding three tables to one

  • Thread starter Thread starter TYE
  • Start date Start date
T

TYE

HI,

Here are the examples, which each field/data have in all 3
tables:

Name
Total Hours
Sales
Completes
Wait time
Talk Time
Wrap up time
Pause time

The result that I want is from all three tables, add up
the following information,

Total Hours
Sales
Completes
Wait time
Talk Time
Wrap up time
Pause time

But I do not want the names of each agent appearing three
times.

Thanks

TYE!
*********************************
TYE,

I am sure what you asking would be possible. If you need
more specific
help, you might need to post back with some more details,
maybe with
examples, of what fields/data you have in the 3 tables,
and what you
want the result to be.

--
Steve Schapel, Microsoft Access MVP


TYE! wrote:
Hi,

I want to add three table to one main table, BUT
The problem is that each table has, got agents name with
they results in.
So I want the query to do is, add all the agency result
plus not have their names add three times
So it will be one main table with all the information
together
Can this be done?
Thanks
 
TYE,

Ok, if I understand you correctly, it may be simplest to think of this
in three steps:

1. Use an Append Query to include the records of Table2 into Table1,
and then another Append Query to include the records of Table3 into
Table1. So now Table1 includes all of the data.

2. Make a query based on Table1, and make it into a Totals Query
(select Totals from the View menu in query design), and then in the
Totals row of the query design grid, in the Name column, leave as Group
By, and then Sum in all the other columns.

3. Then, make a blank table exactly the same structure as the original
tables, and make the query from Step 2 above into an Append Query and
add all the data from this query to the new blank table. This way you
end up with one record for each person, with the totals of all data for
that person from the 3 original tables.
 
Back
Top