There are various reasons that people tell you to avoid LOOKUP fields. You have one. Down the road it will bite you on the butt. In fact, for the simple query I will show you, it already has.
You also described two tables named Table2. I'm going to assume that the first table is really Table1.
OK, to find how much leave a person is taking in a given year, you might need a query similar to this:
SELECT SUM([EndDate]-[StartDate]+1) AS Days, LeaveType, Firstname, Lastname
FROM Table1 INNER JOIN Table2 ON Table1.EmployeeID = Table2.EmployeeID
WHERE StartDate > ( Date() - DatePart( "y", Date() ) )
GROUP BY LeaveType ;
The theory of this is you will get 0, 1, or 2 entries. Zero for people who have not taken any leave at all, one for folks who took only one kind of leave, and two for folks who took both kinds of leave. The WHERE clause uses DatePart with "y" to compute something called Julian date, the day of the year. It uses the ">" sign because that particular computation generates Dec. 31 of the previous year.
Note also that if you wanted to look at last year's leave totals, life gets more complex as you then need a more complex method of limiting dates.