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

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!
 
J

John Vinson

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..."
 

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

Similar Threads

Adding data to MS Access from csv file 0
Creating new table with fields from existing ones.... 1
How do I clear a form? 0
Make table query: [Enter 1] AS Test 1
Access 2013: Form problem in reading data tables; relationship one-to-one 0
Merging from an Excel file with graphics 1
Migrating from 2010 to 2013 - having issues: Exporting to xml 0
Create New Table/Column 1

Top