Retrieving a specific record from a query

[David Robinson]

I have a report, the detail section of which lists records (basically a
personnel roster) from a query. So far so good. The report header consists
entirely of a subreport, based on a different query, which contains the basic
information about the assignment to which the personnel are assigned. The
report duplicates an existing form and there is a block in the header where
the supervisor (who is also included in the personnel roster) will also be
entered.

How can I find the supervisor in the main report's underlying query and
include him/her in the header subreport?

Thanks in advance.

 

[KARL DEWEY]

In the query for the header subreport add the query for the main form and
left join it to the table for the subreport.

 

[David Robinson]

I think I understood just enough of what you said to figure it out.

Thanks!