I have a list box in a form that from a query:
What I want to do is find the last tblEmpVac.EMPVACID number (end of record) and then select the date.Code:SELECT tblEmpVac.EMPID, tblEmpVac.VACID, tblEmpVac.EMPVACDate, tblVacation.PERID, tblEmpVac.EMPVACID FROM tblVacation INNER JOIN tblEmpVac ON tblVacation.VACID = tblEmpVac.VACID WHERE (((tblEmpVac.EMPID)=1) AND ((tblVacation.PERID)=1));