I'm trying to create a query in MS Access to return a list of records that have the most recent date in one of the fields. Using Max or Last aggregate isn't doing it. How do I get the correct results?

Thanks!