Only show new date

[Guest]

I’m working on a query that I would like to show the latest date. I have the
following.

Course Name
End_Date

And other fields

So if I have the course First Aid ending on 1 Jan 04 and 23 Jun 04 ONLY
First Aid 23 Jun 04 would come up.

Thanks

Keith

 

[Guest]

Use a Totals query and select Max.

 

[John Spencer]

You can do this with a coordinated subquery.

SELECT [Course Name], End_Date, ...YourOtherFields...
FROM YourTable
WHERE End_date=
(SELECT Max(End_Date)
FROM YourTable as T
WHERE T.[Course Name] = YourTable.[Course Name])

If you are using the query grid and have all the fields in the query, then the
End_Date column should look something like:
Field: End_Date
Criteria: (SELECT Max(End_Date) FROM YourTable as T WHERE T.[Course Name] =
YourTable.[Course Name])