Grabbing Data from Multiple Tables & Pasting it into Another?

C

Curtis Stevens

How do you go about grabbing a record or two and its associated data from
multiple tables and pasting it into another table? Using a append query work?
 
K

KARL DEWEY

You join the multiple tables on related fields, use criteria to select the
records, and change the query type to append.
 
J

John W. Vinson

How do you go about grabbing a record or two and its associated data from
multiple tables and pasting it into another table? Using a append query work?

Yes... but why would you want to store data redundantly? What benefit do you
see from storing this consolidated record in a table which cannot be attained
by just using the select query that grabs the data?
 

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

Top