Collating info from 2 tables

[Lyncroft]

I have 2 different databases holding 1 table each. For ease of purpose, each table has 2 fields. Both tables hold similar info but have different field names.

How can I collate the info from each of the tables into just one table. The amount of records in each table will be added to on a regular basis. I was thinking of some sort of Append query perhaps?

Any ideas?

 

[Sohaila Taravati]

You can link the table to one of your databases and make a union query!

 

[Lyncroft]

Hello Sohaila

Thanks. I had just been thinking about that!!! I'll give it a go tomorrow.

Cheers for the confirmation that I'm on the right path!!!!