Earlier Date

[Guest]

Hi, I have a table as following:

Name Date of Service
MMM 01/05/05
MMM 02/12/05
MMM 03/07/05
VVVV 10/20/05
VVVV 11/01/05

I just want to select the earliest date, for example: 01/05/05 for MMM and
10/20/05 for VVVVV. Please help me to write a query for this. Many Thanks.

 

[Vincent Johns]

This should do it:

SQL:

SELECT Service.Name,
Min(Service.[Date of Service]) AS Earliest
FROM Service
GROUP BY Service.Name;

Query Datasheet View:

Name Earliest
---- ----------
MMM 1/5/2005
VVVV 10/20/2005

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.

 

[Guest]

It works very well. Thank you so much, Vincent.