Access 2000 query question

I have an access query which returns records based on a comparision between record date, expiry date and todays date. If 2 particular fields are duplicated in the results I need the query to return the records with the most recent record date. What function would I need to use to implement this?