I have the following table as an example in MS Access 2010. I need to filter the table so there is only one row for each Name.
The criteria is that the Date must be most recent BUT no later than today's date (6th April).
Name Date Team John 04/04/2018 A John 02/02/2018 B James 10/10/2018 A James 03/03/2018 C Matt 08/09/2018 D
This is the result I'm looking to get.
Name Date Team John 04/04/2018 A James 03/03/2018 C
My problem has been trying to filter this data while grouping the Names.