Selecting last record only

wllsth

Registered User.
Local time
Today, 10:57
Joined
Sep 17, 2008
Messages
81
I have created a query which shows 2 fields "Project Name" and "Date Worked". I want to show/select only the latest record (shown in red below) :-

Project Name Date Worked
753 17/10/2008
753 16/10/2008
753 15/10/2008
753 13/10/2008
758 18/10/2008
758 17/10/2008
758 15/10/2008
3979 22/10/2008
3979 17/10/2008
3979 16/10/2008
3979 15/10/2008
3979 14/10/2008
3979 13/10/2008

How do I do it
 
Last edited:
Select [project Name], Max([date Worked])
From [yourtable]
Group By [project Name]
 
Thanks a bunch
 

Users who are viewing this thread

Back
Top Bottom