You have all this info in one table, plus you have employee first and last name in one field? If the answer is yes to either, it would not be a good example of normalization. To answer your question without knowing that or what makes a payslip current, or which fields you want, or what the data types are, or where the criteria is coming from, I'd guess
Code:
SELECT * FROM EmployeePay WHERE employeeID = 1 AND PayDate > TheLastPayDate
where 1 is, I presume, the employeeID and PayDate is also fed to this somehow. I guess that this isn't a filter either. Rather, I take it that this is to be the record source for the report.
Last edited by Micron; 07-30-2017 at 06:56 PM.
Reason: code correction
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.