Query Help

[Manik]

Lets say I have table like this.


BuildingName BuildingRanking CertificationDate
----------------------------------------------------------
A 51 5/6/02
A 76 6/4/03
B 87 7/8/01
B 91 10/3/01

What should be my querry to pull up the Building Name and
its latest Building Ranking., i.e., ranking assigned
recently.

 

[John Spencer (MVP)]

One method:

SELECT BuildingName, BuildingRanking, CertificationDate
FROM Tablename
WHERE CertificationDate =
(Select Max(T.CertificationDate) as LastDate
FROM TableName as T
WHERE T.BuildingName = Tablename.BuildingName)

 

[John Spencer (MVP)]

That means Access doesn't know what "BuildingName" is. Make sure that you
replaced your field names with the ones I used in the example.