SQL SELECT Max date and = id

I am trying to select from a tbl the LATEST date and also where the ID is = 'x'.

What seems to be wrong with this? I am sooooo lost in SQL.

Thanks
heaps

SELECT tblPTSENDams.damName, tblPTSENDamData.maxCap, tblPTSENDamData.relLevel, tblPTSENDams.purpose, tblPTSENDamData.currentCap,
tblPTSENDamData.dateLastMeasured, tblPTSENDams.damID, tblPTSENDamData.damID AS Expr1
FROM tblPTSENDamData INNER JOIN
tblPTSENDams ON tblPTSENDamData.damID = tblPTSENDams.damID
WHERE (tblPTSENDamData.dateLastMeasured =
(SELECT MAX(dateLastMeasured) AS Expr1
FROM tblPTSENDamData AS tblPTSENDamData_1
WHERE tblPTSENDAMData.damID = 4))

http://sqlteam.com/forums/topic.asp?TOPIC_ID=69648


greets,
Emiel