Making a new table from fields of more than three other tables??

[teresap]

This is probably very easy to do if you have the knowledge, unfortunately I do not and if anyone can help or advise I would be truly grateful. I have a database that consists of five different tables each containing a list of clients relevant to that table. What I wish to achieve is to have a further table simply showing all the clients from all the other tables without typing them all in. I have tried making a query but it wants the relationships joined and when I do this it does not list all clients it only shows the minimum number. In other words table 1 has 15 clients whereas table 2 has 8 clients when I run the query I only get a list of 8 clients from each table all I wish to achieve is have a list of all clients from all tables. Is this possible?

Many thanks if anyone can help.

Teresap

 

[Rich]

Normalise your data by Appending the data from each table to a new single one

 

[teresap]

Rich,

Many thanks can you explain further, I am really new to Access and whatever I have tried doesn't work. Unfortunately I need it to be explained in simple terms.

Regards

Teresap

 

[teresap]

Thanks got there in the end

Rich,

Many thanks, after a little bit of playing around and checking for append query selections I found it and it is working. Thanks again

Teresap