P
paradigm
I have a table with fields ID, ProjectNo and IssueDate and a few others
There are multiple records with different dates for each project
I need to find the minumum date for each project which I can do with
SELECT INVOICES.ProjectNo, Min(INVOICES.IssueDate) AS MinOfIssuedate
FROM INVOICES
GROUP BY INVOICES.ProjectNo
ORDER BY INVOICES.ProjectNo;
This will return a single record for each project with the minimum date
However, I need the ID of the records. If I add the ID into the query as a
groupby then each record is now unique and all records are returned for each
project.
How can I find the record ID of the records returned in the first query.
Alex
There are multiple records with different dates for each project
I need to find the minumum date for each project which I can do with
SELECT INVOICES.ProjectNo, Min(INVOICES.IssueDate) AS MinOfIssuedate
FROM INVOICES
GROUP BY INVOICES.ProjectNo
ORDER BY INVOICES.ProjectNo;
This will return a single record for each project with the minimum date
However, I need the ID of the records. If I add the ID into the query as a
groupby then each record is now unique and all records are returned for each
project.
How can I find the record ID of the records returned in the first query.
Alex