Might be missing the point here, but can it not be done with a subquery? Something like this:
PHP Code:SELECT SSN
FROM EmploymentRecords
WHERE DoS In (SELECT Min(DoS) AS FirstDate FROM EmploymentRecords GROUP BY SSN)
|
Results 1 to 1 of 1
Thread: Access Select
|
Click Here to Expand Forum to Full Width |
Reply With Quote