Hi I need some help linking some tables...
Does anyone knoe how i would go about taking several years of contact information and compine it all into one table

Thanks

I assume therefore that the data is in different tables so

1) Are these different tables of the same design
2) Are the fields you wish to combine into one table the same size and type

If the tables are identical (apart from content then a copy and paste is all that is required.

If they are different then you need to ask why they are different and what is going to get screwed up by making them the same

Finally are you sure you want to combine them

Len

Just to add to what Len has said:

If you want to permanently combine the data then a cut an paste or an append query will get the records into a single table.

If you need to keep that data in separate tables, then a union query will bring the distict tables together.