Hi there, this is a question concerning merging 2 tables in Access.

I have 2 tables with a common field "timestamp".

Table 1 has timestamp, field 1, field 2.
Table 2 has timestamp, field A, field B (for example).

New table will have timestamp, field 1, field 2, field A, field B and the records will be made from records in the 2 original tables with common timestamp values.

How do I do that?

Thanks!!