Return only Last Dated Entry

[TamaraR]

I have built a database that holds information on different wells. I have all the wells with their information in one table and another table holds each sampling event for the wells. (The sampling is donequarterly but over a three week span. Each well record is linked to many records containing sampling information. I would like to make my query for a report return only the information for the last date that the wells were sampled. Then I can print reports with only the most recent information.

Any help on this is appreciated.

Tamara

 

[tlbroadbent]

The general syntax for doing such a query is as follows.

Select t.* From SampleTable As t
Where SampleDate =
(Select Max(SampleDate)
From SampleTable
Where WellID=t.WellID)
Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions in the SQL Server forum. Many of the ideas apply to all forums.