Horizontally merge (combine, match, union) two Access tables into one by a common column (field) of data. The two tables can be located in the same Access file or two different Access files. No complicated options or SQL knowledge required. For Access experts, this is similar to an OUTER JOIN where a new table is created with the results.
|