ms access: retrieving latest value

Question

I have a table Project. It has the following column:
Project ID, projectName, UpdateTime

The data in the table is as follows:

  Project ID   projectName   UpdateTime
       1          abc        12-2-2009 01:10:00
       1          abc        12-2-2009 04:18:00
       2          xyz        17-7-2009 08:45:00
       2          xyz        17-7-2009 12:21:00

i want the result set to display the latest update project information based on the update time.
for the above example , it should display

  Project ID   projectName   UpdateTime
       2          xyz        17-7-2009 12:21:00
       1          abc        12-2-2009 04:18:00

Answer 1

This ought to do the job (as edited to reflect the information @Remou pointed out that I failed to note in your original question):

  SELECT [Project ID], ProjectName, Max(UpdateTime)
  FROM Project
  GROUP BY [Project ID], ProjectName
  ORDER BY Max(UpdateTime) DESC

If that doesn't do it, either I've made a mistake, or there's other information not included in your question.

Answer 2

SELECT P.[Project ID]
     , P.projectName
     , Max(P.UpdateTime) AS [Latest Update Time]
FROM Project AS P
GROUP BY P.[Project ID]
     , P.projectName
ORDER BY Max(P.UpdateTime) DESC;