SELECT tblLeave.EmployeeID, tblLeave.DaysGiven, tblLeave.DaysOnLeave, [tblLeave.DaysGiven]-[tblLeave.DaysOnLeave] AS DaysLeft
FROM tblLeave
WHERE (((tblLeave.EmployeeID) Like [EmployeeID]));
Something like that could work, you would just have to adapt it. OR the best way (for tracking purposes)...