Hi all
Can anyone help
What I want to do is to create a new table based off 2 other tables.
some of the data is common but the field names are not.
I basically want it all in one table (i know some of the data wont be the same in each field)
I have looked a union queries, linked...