P
paradigm
I have a table with fields ID, ProjectNo and IssueDate and a few others.
There are multiple entries for each ProjectNo
I want to find the earliest issuedate for each project.
I can do this with a query
SELECT INVOICES.ProjectNo, Min(INVOICES.IssueDate ) AS MinOfIssueDate
FROM INVOICES GROUP BY INVOICES.ProjectNo;
However I need to find the IDs of the records returned. If I add the ID to
the query then each record is unique and it returns all the records instead
of just the earliest dates.
How can I find the IDs of the records?
Alex
There are multiple entries for each ProjectNo
I want to find the earliest issuedate for each project.
I can do this with a query
SELECT INVOICES.ProjectNo, Min(INVOICES.IssueDate ) AS MinOfIssueDate
FROM INVOICES GROUP BY INVOICES.ProjectNo;
However I need to find the IDs of the records returned. If I add the ID to
the query then each record is unique and it returns all the records instead
of just the earliest dates.
How can I find the IDs of the records?
Alex