Hello. For a query, I have this SQL code that works well.
Code:
SELECT Min(tblmod.dates) AS date1, Max(tblmod.dates) AS date2, tbltaks.tbltaskname, Format(Sqr([Qty]),"Standard") AS rc, tblmod.plot_idFROM tbltaks INNER JOIN (tblplot INNER JOIN tblmod ON tblplot.plotid = tblmod.plot_id) ON tbltaks.task_id = tblmod.task_id
GROUP BY tbltask.tbltaskname, tblmod.dates, tblmod.plot_id
HAVING (((tblmod.plot_id)=54))
ORDER BY tblmod.dates;
However, I am looking for an SQL code to group tasks stored in successive dates into a single row.
I have been searching the web but I don't know type the correct keywords.
In the attached image:
The table on the left is my SQL code.
The table on the right is the one I need to program.
I really appreciate your help.