I have a table with columns
EmployeeID (Primary Key)
I like to create a query to generate a table of the latest claim for each employee since Jan 1, 2013. In the table there can be more than one records related to a EmployeeID. Records before Jan 1, 2013 will not be take into consideration.
The result should have the same column as the above table.
Can anyone give me an idea how to do that? Thanks.