How can I split 3 tables in Microsoft access 2003?

[sibby]

Hi I have 3 tables in Microsoft access and I would like to split them into 5, however my usual way of splitting the tables using the analyse tool doesn't work as some of the data fields I require are in different tables (using the analyse tool you can only split the data from one table)





any suggestions as to what I could do are kindly appreciated, I would also like to add that the three tables where added by using 3 different text files and if it is easier to merge the three text files into one and then use the analyse tool how could i go about this ?

[Datagopherdan]

I'm assuming that you're splitting them to further breakdown data e.g. unique locations from the 3 tables placed into a single table. If that being the case, you can do a union query to get all the unique values for a given field for the 3 tables such as below.

SELECT Table1.Location
FROM Table1;
UNION
SELECT Table2.Location
FROM Table2;
UNION
SELECT Table3.Location
FROM Table3;