Retrieve the last record in a table

[DC CS]

Good day all,
I have an access table with Vehicle registration numbers and checklist dates. There are multiple records of the same vehicle registration number, but each record has a unique date. See below:




I only want to see record 1 and 3.
I tried DFirst, DLast and had a look at several suggestions on the forums, but none is giving me the results I am looking for.

I do not know beforehand what the registration numbers will be. I need to retrieve those registration numbers by retrieving the last date captured for each registration number.

Thanks

[Welshgasman]

Use Dmax() on the date and group by reg number.

Edit: Sorry I meant Max()

[NoellaG]

select max(MyDatefield) from MyTableName group by MyRegNumberField
If you want to see all data fields connected to this combination: save the groupsquery and use it in a second query linked to the Vehicle registrations table on the regnumber field + date field

[DC CS]

Thanks a lot - solved!