relationships across sheets

[jppevy]

I am new to access, so this is an entry level question.

If I have two sheets: one with employee information of say 500 cells, each marked by a unique ID. I have another sheet with about 50 cells, with some of the same employees and their vacations days. The second sheet has the same IDs as the first sheet, of course. IF I want to create a new sheet, or at least combine the data from the second sheet into a new column in the first: How do I do this? Again, the first sheet has all employees, and the second only some. Below should help explain this visually.

Table 1

Emp ID	name
1	John
2	Sarah
3	Tim

Table2

Emp ID	vacation days
3	14
17	20
80	10

Thanks again!

[Dal Jeanis]

Are you talking about Excel, rather than Access?

In Excel, I'd select the area on the second (optional) sheet, make that area a named table, and use the VLOOKUP function in cells on the first sheet to populate data from the second sheet.

In Access, you wouldn't **combine** the two tables, you'd just LEFT JOIN them into the query whenever the data was relevant.

Start a new query in query design view.

Add the two tables.

If the relationship is not already there, drag a line between the key field of each table.

Now, right-click the relationship, and set the relationship type to include all the records on the "name" table, and only the matching records from the "vacation" table.

Now you have a query that you can use to make reports.

[jppevy]

solved. thanks!