Create new table/file from two existing tables...

  • Thread starter Thread starter Hunter
  • Start date Start date
H

Hunter

I am attempting to combine selected fields from 3
different tables so that I can output the result to an
Excel file, thereby allowing me to import into ACT! as
one database.

Ex: Contact table has 2107 records, and Company table has
3498 records, and the table that relates contacts to
company has only 1894 records. I need a new table which
has 2107 records with contact AND company information.

Is there a way I can do this with a query?

Is there an easier way to just create a 3rd table with
fields from existing ones? Help!
 
Ex: Contact table has 2107 records, and Company table has
3498 records, and the table that relates contacts to
company has only 1894 records. I need a new table which
has 2107 records with contact AND company information.

Is there a way I can do this with a query?
Click to expand...

Certainly. Take your Query joining the two tables, and select the Join
line from the Contacts table to the related table in the query design
view. Choose the option "Show all records in Companies and matching
records in..."
 
Back
Top