combine tables into a "master"

G

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

combine tables 3
Combine multiple tables into one 8
Need help creating a Master Query 4
Merge or Combine Tabels 4
Combine Tables Into One 2
COMBINE TABLES IN ACCESS 3
Lookups - how to obtain data from a master spreadsheet into another 5
Combine 10 mdb files with different fields but common emp codes 3

Top