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
 

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

Turning a 3 column flat file into a "3D" Table 2
Combine data in two records from same field 16
combining rows of data 4
Access Question 4
2 Relationship Query 1
Combining databases - Common People table, many other tables. 4
primary key - concatenated or autonumber? 6
Insert multiple .dat files into one pdf without losing color of their graphs 0

Back
Top