combine tables

[Guest]

I will have weekly tables added to the data base, and i'd like to know how to
combine these tables into a "master" (same field headings, with the latest
table's data added to the end of the master table as new records) so i can
create graphs in excel by using the pivot tables. This process needs to be as
easy as possible. I remember doing it once with literally just a click of a
button, but frustratingly, i've forgotten how.

Again, this will be an ongoing process, and i would preferably not have to
keep modifying queries/codes

Thanks!

 

[Joseph Meehan]

I will have weekly tables added to the data base, and i'd like to
know how to combine these tables into a "master" (same field
headings, with the latest table's data added to the end of the master
table as new records)

Note: data in tables do NOT have an order. The idea of adding them to
the "end" of the mater table is not meaningful. Do not rely on the data in
a table being in or staying in any sort of order. If you need an order, YOU
have to provide it by using or providing and then using a field that has
data that can be sorted in the order you need.

so i can create graphs in excel by using the
pivot tables. This process needs to be as easy as possible. I
remember doing it once with literally just a click of a button, but
frustratingly, i've forgotten how.

Again, this will be an ongoing process, and i would preferably not
have to keep modifying queries/codes

Thanks!

There are many possible ways of doing this. Since we don't know exactly
how you will be receiving the data and exactly what formation it will be in,
it would be very difficult to suggest the best solution.

For example will the information be made available on a LAN, or e-mailed
etc. Will the data be in the form of an Access file or a comma delineated
format or what?

 

[Rick B]

I guess the question would be why you are creating a separate table every
week? You only need the master table. In your queries, reports, and forms
that should only show the current week's details, you'd simply include a
filter to pull out the appropriate records.

Any time you have to constantly create tables (that are identical to others)
or move records from one table to another, you probably have a design flaw.

 

[Joseph Meehan]

I guess the question would be why you are creating a separate table
every week? You only need the master table. In your queries,
reports, and forms that should only show the current week's details,
you'd simply include a filter to pull out the appropriate records.

Any time you have to constantly create tables (that are identical to
others) or move records from one table to another, you probably have
a design flaw.

That's a good point. I was thinking that he was getting the data from
another area, but he really does not say that. Let me add my opinion that
if the data can be added directly to this database that is the way to go.
Don't use two systems to do what one will do far better.