Hi,
Please can someone help! I am building a staff list database and currently have 9 tables showing staff that work on particular project areas. Some staff work on more than one, but we'll come to that in a minute. All I want to do is combine the 9 tables as they look into one long table to show everyone that works across our organisation. When I used the Microsoft Help pages to do this, I followed the instructions and ended up with tables of data side by side in a very wide table, and the data was scrambled for most of it.
One issue - I don't have a primary key set at the moment - it was the first name field for each table, but it was suggested I remove it during a problem i had with a different query type.
So - next I tried lumping fields together in the query design, seperated by '+' operands, so that fields would appear by table in successive order, but this collected them into 'Expr1', 'Expr2' etc. for each table and that's not what I want.
Can someone please guide me through step-by-step so that I can just have one table that flows with the same column headings that the individual tables have?
Another thread will be then how I automatically deduplicate data in the master table I have created.
Any advice gratefully received!
Many thanks,
Periolus