combining 3 files into one

  • Thread starter Thread starter Amy
  • Start date Start date
A

Amy

i have 3 files - each with different data on a group of people, all with an
ID number. I created relationships but now what? I need to combine them all
into one file. HELP PLEASE!
 
If all three have the same fields then use a union query.
If they have different fields then use a left join from the 'one' table to
the 'many' table.

If you need further assistance then post the table structure with field
names and datatype.
 
Amy,

By three 3 files do you mean tables? Before you combine what are the fields
in those tables. A query may work for your needs but more information is
needed. Oh, and you might tell tell us what you are trying to do as it will
help us to give you a more precise answer.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm
 
Back
Top