Report by Filter

[ridgeandgable]

Hi Guys



I've found my old database on the internet that I made way back in 2009 amazed to still see it, but I've forgotten some of the basics

I have a table & form called EmployeePay which has employeeID, EmployeeName, PayDate, HourlyRate, Tax, NI, Deductions, TotalPay

I need to create a filter so when I click on payslip from the form, it will open a report showing the current pay slip which I would imagine would be something like

Select Employee Name & Date = (Shows that 1 record)

Can someone help

Cheers

[Micron]

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

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.