SELECT Guests.ID, Guests.[Last Name], Guests.[First Name], [Guest Attendance].[Overnight/Dinner Only]
FROM Guests INNER JOIN [Guest Attendance] ON Guests.ID = [Guest Attendance].ID
GROUP BY Guests.ID, Guests.[Last Name], Guests.[First Name], [Guest Attendance].[Overnight/Dinner Only]
HAVING...