SQL statement for latest record

Thanks guys. I'll try them and report back.
I should have said I'm running it in Access 2016.

I understood the first one. Good question Vitor.

It remembers me those 1001 ways to code the "Hello World" program to try to be as much complicated as you can :)

The first solution doesn't return the latest record but a list per ID with its maximum date.

Maximum date is not only the latest date? Or what other interpretation for latest should we have?
And per author requirement I think is really what is pretended:
"So in this sample data it will return 3 records, ie. the 3rd, 4th, and 6th one."

Like I said, what if there are other columns in that table? The query that will return the latest record is this:

SELECT 
	*
FROM 
	myTable t
where
	exists (select * from myTable where ID=t.ID and [DateTime]=(select top 1 [DateTime] from myTable where ID=t.ID order by [DateTime] desc))

Select allOpen in new window

ANd that is only if the ID+DateTime combination is unique!

So we're entering in the assumption world and not sticking in the question requirement that only has a table with 2 columns.

No, we give an answers for all possible situations but the question was clear: "the last record". There is nothing wrong with that as it was nothing wrong with the first solution either. The asker can judge for himself which one suits his case better.

Whoa! Actually you're all helpful.
The first solution showed me the way. I tried it. It worked as I expected.
However, it is true that I wanted to then add 2 more fields. For that I needed the rest of the solution, as I could now see that just adding the fields to the same SELECT doesn't do the job.

The discussion also helped.

What a wonderful forum this is!
Thanks all.

Glad that it worked for you !! Yes more often we require all the columns that corresponds to the maximum value based on the grouping.