Max Date Value per Name ID

[Guest]

In researching my question, I found the following statement that works for
me. I am trying to obtain, per person, the latest record. One question: I
need to use two date fields as Max...a Notes field (short date) and the
Create date (date/time). In the table, it's possible to have the same Notes
date but different create date. How would I add this to the statement below?

Statement that I found on this forum:

If you want to select the latest record for each person:

SELECT table.*
FROM table
WHERE table.datefield = (
SELECT Max(X.datefield)
FROM table As X
WHERE X.personid = table.personid)

--

 

[Guest]

This works on my data --
SELECT [change requests].*
FROM [change requests]
WHERE IIF([change requests].[date open] > [change requests].[date close],
[change requests].[date open], [change requests].[date close])=
(SELECT iif(Max(XX.[date open]) > Max(XX.[date close]), Max(XX.[date open]),
Max(XX.[date close]))
FROM [change requests] As XX
WHERE XX.Y = [change requests].Y)