I have a report that displays all staff names and dates of when they were checked so some staff have mulitple results as they are checked randomly.
I need the report to only display the most recent check date from the mulitple results but there isnt a set criteria to select from - eg the last one for Joe bloggs within the past 30 days.
How do i do this?