Accessing Most Recent Record in a Query

[camelk]

I have a table that stores patient progress reports. The Composite key is Patient Number (PtNo) and Date of Progress Report(DatePR). I have a query that accesses the records from the table. But....I want the query to access only the most recent record for each patient number. How do I write criteria that will let me do this.

 

[tlbroadbent]

Try this.

Select p.*
From PatientProgress As p
Where p.DatePR =
(Select Max(DatePR)
From PatientProgress
Where PtNo=p.PtNo) If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm