Records that match ALL items in a listbox

[danvlas]

Hello all,

Setup:

Employees (one)->(many)EmployeeCourses(many)<-(one)Courses

I've made a multiselect listbox (based on table Courses) on a form displaying all courses.

I need to create a query to list employees that have taken ALL selected courses.

No matter what I do, I can only list employees that have taken or have not taken any of the selected courses, but not all. And I just can't figure out the logic...

Can anyone give me a hand here?

Thanks in advance




Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[danvlas]

I made it, nevermind.

EmpID In (Select Employee From tCourseSchedule Where Course In(1,2,3) Group By Employee Having Count(EmpCrsID)=3)

(1,2,3) is built dynamically from the listbox and the final 3 is taken from ListBoxName.ItemsSelected.Count

I thought someone might find this useful...




Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html