I have an Access’97 database which contains the following fields: NAME, DATE.
There are multiple records in the database for the same name but a different date each time so one person may have 10 records (using the same name) but each record willhave a different entry in the date field.
Do you know which query/argument/function I can use if I just want to pull out the records with the most recent date on them?
i.e. the most recent record for that person.
