I inhered a set of queries / macros from the previous employee in my position and one of the other people here showed me a query result (output from when the query worked correctly) which had subheadings as well as rows. They described it as a report.
In reconstructing how the series of queries worked I determined that first the rows of the employers were added to a table. Next a list of employees were added to the same table. And finally it was sorted on a hidden row which placed the employees under their subsequent employers.
This seems to me to be a very unnatural thing to do with a query...my first instinct is to place it in some other kind of report so that it loops through the employers and adds the employees below them in a sub loop; running the employee query multiple times for each employer.
Is there a name for a query like this so I can look up the technique he is using in a book? Is it an unnatural thing to do because the actual field headings don't really apply to the rows with the employer records?