Oldest date (1 Viewer)

[sandhurstUK]

Hi,

The following code selects a list of surveyors and a list of dates.
What would be the next line of code to select just the oldest date per surveyor?


SELECT [Current NBIs Grouped qry].Surveyor, [Current NBIs Grouped
qry].[Allocation Date]
FROM [Current NBIs Grouped qry]
GROUP BY [Current NBIs Grouped qry].Surveyor, [Current NBIs Grouped
qry].[Allocation Date];

Thanks
Ian

 

[Rich]

Look up Max([MyDate]), there have been numerous examples posted here

 

[sandhurstUK]

Derrrrrr

Sorry folks, it was a bit early when I posted that.

SELECT [Current NBIs Grouped qry].Surveyor, Min([Current NBIs Grouped qry].[Allocation Date]) AS [MinOfAllocation Date]
FROM [Current NBIs Grouped qry]
GROUP BY [Current NBIs Grouped qry].Surveyor;

This worked fine.