Philip B asked:


This is probably very basic, but I’ve been struggling over the last couple of hours with it:

I have two tables in Microsoft Access 2007. Table 1 has ~200 people and Table 2 has about ~100 people. All of people in table 2 are also in table 1. Each person has a unique identifier.

I want to expand Table 1 to include data that is found in columns in Table 2.

The tables could be referenced by their common identifiers.

Thanks!

Vinyl Siding Cost