I am building a simple task tracker to keep a record of tasks being passed back and forth between our team. The schema is fairly simple as illustrated in the image below.
I want a recordset as follows out of this database (+/- few columns. But these are the most essential ones needed) -...