I posted a question earlier on how to return first and last dates by year:
https://access-programmers.co.uk/forums/showpost.php?p=1614857&postcount=1
Colin (isladogs) kindly solved this for me.
In his solution, the Union query returns 2 records. One for the first date, and one for the last date
The query is:
How can I create one record from the two queries?
yYear, FundId, FirstDateInYear, LastReportingDate
Thanks in advance
https://access-programmers.co.uk/forums/showpost.php?p=1614857&postcount=1
Colin (isladogs) kindly solved this for me.
In his solution, the Union query returns 2 records. One for the first date, and one for the last date
The query is:
SELECT yYear, FundId, FirstDateInYear FROM qryFundFirstStatementDateForYear
UNION SELECT yYear, FundId, LastReportingDate FROM qryFundCorrectedLastStatementDateForYear;
How can I create one record from the two queries?
yYear, FundId, FirstDateInYear, LastReportingDate
Thanks in advance