combining 3 files into one

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

KARL DEWEY

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

Gina Whipp

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
 
Top