Please help! Trying to use one query in a report and another query in subrpt

[floyd33 via AccessMonster.com]

This is the query I use to show all records for meetings between date and
date in a report. What would have to change to show all employees not
assigned to a meeting between date and date in a subrpt to be inserted in a
report footer of the first report?

SELECT [qryConfirmed 2001 Meetings].*
FROM [qryConfirmed 2001 Meetings]
WHERE ((([qryConfirmed 2001 Meetings].[Meeting Planner]) Like [Enter Meeting
Planner First Name or Press OK for All]) AND (([qryConfirmed 2001 Meetings].
[Start Date]) Between [Enter First Date] And [Enter Second Date]) AND ((
[qryConfirmed 2001 Meetings].ContractStatus)="Awarded" Or ([qryConfirmed 2001
Meetings].ContractStatus)="Confirmed" Or ([qryConfirmed 2001 Meetings].
ContractStatus)="Postponed" Or ([qryConfirmed 2001 Meetings].ContractStatus)
="pending")) OR ((([qryConfirmed 2001 Meetings].[Meeting Planner]) Like
[Enter Meeting Planner First Name or Press OK for All]) AND (([qryConfirmed
2001 Meetings].ContractStatus)="Awarded" Or ([qryConfirmed 2001 Meetings].
ContractStatus)="Confirmed" Or ([qryConfirmed 2001 Meetings].ContractStatus)
="Postponed" Or ([qryConfirmed 2001 Meetings].ContractStatus)="pending") AND
((([Start Date]) Between [Enter First Date] And [Enter Second Date]) Is Null))
OR ((([qryConfirmed 2001 Meetings].[Start Date]) Between [Enter First Date]
And [Enter Second Date]) AND (([qryConfirmed 2001 Meetings].ContractStatus)
="Awarded" Or ([qryConfirmed 2001 Meetings].ContractStatus)="Confirmed" Or (
[qryConfirmed 2001 Meetings].ContractStatus)="Postponed" Or ([qryConfirmed
2001 Meetings].ContractStatus)="pending") AND ((([Meeting Planner]) Like
[Enter Meeting Planner First Name Or Press OK for All]) Is Null)) OR (((
[qryConfirmed 2001 Meetings].ContractStatus)="Awarded" Or ([qryConfirmed 2001
Meetings].ContractStatus)="Confirmed" Or ([qryConfirmed 2001 Meetings].
ContractStatus)="Postponed" Or ([qryConfirmed 2001 Meetings].ContractStatus)
="pending") AND ((([Start Date]) Between [Enter First Date] And [Enter Second
Date]) Is Null) AND ((([Meeting Planner]) Like [Enter Meeting Planner First
Name Or Press OK for All]) Is Null));