Creating a new table by combing two others within a database

M

Moki

I want to create a new table by pulling data from one table IF it matches
data in another table.

Example: I have a mailing list in one table and a separate table with just
zip codes. I want to create a new table that extracts data from the mailing
list IF the zip code in the mailing list matches the zip codes in the zipcode
table.

Can someone please tell me how to do this?
 
O

Ofer

Create a query that include both tables linked by the zip code field, inner
join.
Check the data that the select query return, if it match your needs, change
the query from select query to create table query (in the menu bar, select
query > create new table), run the query and you'll have a new table that
return the appropriate data.
 
J

John Vinson

I want to create a new table by pulling data from one table IF it matches
data in another table.

Example: I have a mailing list in one table and a separate table with just
zip codes. I want to create a new table that extracts data from the mailing
list IF the zip code in the mailing list matches the zip codes in the zipcode
table.

Can someone please tell me how to do this?
Click to expand...

As Ofer says, just create a Query joining the two tables by Zip code.

However, there is NO need nor benefit to creating a new Table. The
information in this table would be redundant - it's already IN your
mailing list table; there's no point in storing it twice (making
corrections to addresses much more difficult, for one thing).

Instead, base a Form, Report, export, or whatever you wish, directly
on the join query.

John W. Vinson[MVP]
 
Top