Grabbing Data from Multiple Tables & Pasting it into Another?

[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?

 

[KARL DEWEY]

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

 

[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?

 

[Curtis Stevens]

I didn't need to do it this way anymore, I can use my query. Was trying to
get it to work with this program: http://www.evermap.com/automailmerge.asp

It does it by ODBC connection and I pasted the sql statements or whatever
you call it and that worked.

nevermind!

Curtis

 

[John W. Vinson]

I didn't need to do it this way anymore, I can use my query. Was trying to
get it to work with this program: http://www.evermap.com/automailmerge.asp

It does it by ODBC connection and I pasted the sql statements or whatever
you call it and that worked.

My apologies for not having my clairvoyance module turned on so I could know
that.