Multi Select field as Query Qualifier

B

brian

I have a list of choices in a field on a form that I want to pass to a Query
and use and IN statement to select. I keep getting no records returned.
Here is the SQL: SELECT Attendees.AttendeeLastName & ", " &
Attendees.AttendeeFirstName AS AttendeeName, Registration.StartDate,
Facility.FacilityName, Courses.EventName AS Course, IIf([Completed]=True,1,0)
AS Complete, IIf([Incomplete]=True,1,0) AS NotComplete, IIf([No
Show]=True,1,0) AS NoShow, IIf([Completed]=False And [Incomplete]=False And
[No Show]=False,1,0) AS Scheduled, 0 AS NotScheduled, Attendees.GroupID,
Attendees.RoleID, Registration.StartTime, Attendees.Designation
FROM Facility INNER JOIN (Courses INNER JOIN (Attendees INNER JOIN
Registration ON Attendees.AttendeeID = Registration.AttendeeID) ON
Courses.EventID = Registration.EventID) ON Facility.FacilityID =
Attendees.FacilityID
WHERE (((Courses.EventName) In ([forms]![rptFacility]![Course])) AND
((Attendees.FacilityID)=[forms]![rptFacility]![FacilityID]))
ORDER BY Attendees.AttendeeLastName;
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top