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!