Make-table help

  • Thread starter Thread starter Allen Clark
  • Start date Start date
A

Allen Clark

I am trying to combine two tables into one spreadsheet. I have a "persons"
table with a unique field called ID that is linked into the "phones" table.
This is a one to many link. Each person can have however many phones as
necessay. Is it possible to use a make-table query to create the excel
spreadsheet that contains the fields from the persons table plus all of the
phone numbers for each person? If so, how does one create such a query?

Thanks in advance,
Allen
 
Alle

If is not neccessary to use a make table query to extract your data to Exel. Just run and save a select query eg

Select A.Name, B.Telephon
From A, B
Where A.Name = B.Nam

Then use File>Export and change Save as Type to Excel

Regard
Rowan
 
Rowan,

You missed the critical point. I have to take data that is in a one to many
relationship and create a tabular list of all of the phone numbers for a
name. One name (id) may have as many as 8 phone numbers associated with it.
I need to create a table that has ONLY one line for each ID and have ALL of
the associated phone numbers and types included on that single row.

I thank you for your response and hope that you or someone might be able to
shead some more light on this problem.

Thanks in advance,
Allen


Rowan said:
Allen

If is not neccessary to use a make table query to extract your data to
Click to expand...
Exel. Just run and save a select query eg:
 
Back
Top