How to take two tables and remove all non duplicates

  • Thread starter Thread starter rr1990
  • Start date Start date
R

rr1990

I have two tables with identical column headings. I need
to take the data from Table A and if there is not a match
(based on a key value) in Table B to eliminate those
records and take the matches and place them in a third
Table. Any ideas would be appreciated as I am fairly new
to using Access.

Thanks in advance.
 
I would not think you would want to create a new table. You are missing the
point of relational databases here.

Build a query and use both tables in the query. Set the relationship so
that only records are pulled if they exist in both tables.

You should (almost) never create a new table that adds data that is already
in a nother table unless you are trying to redesign a poorly designed
database. A properly designed relational database will let you get what you
need from queries.



Rick B
 
Back
Top