If this helps ... this is where I'm at on the statement:
SWITCH(Iff tblCrew_Event_Assignments.Name, tblCrew_Event_Assignments.[Call
Number]
FROM tblCrew_Room_Assignments, tblCrew_Event_Assignments
GROUP BY tblCrew_Event_Assignments.Name, tblCrew_Event_Assignments.[Call
Number], tblCrew_Event_Assignments.[Event Name],
tblCrew_Event_Assignments.Position
HAVING (((tblCrew_Event_Assignments.[Event Name])=[Forms]![frm All
Events]![Event Name]) AND
((tblCrew_Event_Assignments.Position)=[Forms]![frmEvent_Part1_Details]![Audio
Position 1 Description Combo]));
=IS NOT NULL
SELECT tblCrew_Event_Assignments.Name, tblCrew_Event_Assignments.[Call Number]
FROM tblCrew_Room_Assignments, tblCrew_Event_Assignments
GROUP BY tblCrew_Event_Assignments.Name, tblCrew_Event_Assignments.[Call
Number], tblCrew_Event_Assignments.[Event Name],
tblCrew_Event_Assignments.Position
HAVING (((tblCrew_Event_Assignments.[Event Name])=[Forms]![frm All
Events]![Event Name]) AND
((tblCrew_Event_Assignments.Position)=[Forms]![frmEvent_Part1_Details]![Audio
Position 1 Description Combo]))
(Iff tblCrew_Event_Assignments.Name, tblCrew_Event_Assignments.[Call Number]
FROM tblCrew_Room_Assignments, tblCrew_Event_Assignments
GROUP BY tblCrew_Event_Assignments.Name, tblCrew_Event_Assignments.[Call
Number], tblCrew_Event_Assignments.[Event Name],
tblCrew_Event_Assignments.Position
HAVING (((tblCrew_Event_Assignments.[Event Name])=[Forms]![frm All
Events]![Event Name]) AND
((tblCrew_Event_Assignments.Position)=[Forms]![frmEvent_Part1_Details]![Audio
Position 1 Description Combo]));
=IS NULL
THEN
SELECT tblCrew_Room_Assignments.Name, tblCrew_Room_Assignments.[Call Number]
FROM tblCrew_Room_Assignments
GROUP BY tblCrew_Room_Assignments.Name, tblCrew_Room_Assignments.[Call
Number], tblCrew_Room_Assignments.[Room Name],
tblCrew_Room_Assignments.Position
HAVING (((tblCrew_Room_Assignments.[Room Name])=[Forms]![frm All
Events]![Part 1 Location]) AND
((tblCrew_Room_Assignments.Position)=[Forms]![frmEvent_Part1_Details]![Audio
Position 1 Description Combo]))
Obviously this is wrong, but hopefully this helps to show you what I'm
trying to do.