Multiple Combo Boxes extracting data from same field- Is this possible?

[samtitus]

I have 2 tables:
Tbl1 - Employee details
Tbl2 - Employee qualifications [an employee can have more than 1 qualification assigned to his ID no]

I need to generate a query/report that will list EMPLOYEES who has ALL selected qualifications. Is this possible and if yes how do I go about it.
nb: a
eg
Form to list the qualification
ComboBox 1 - Qualification1 - info extracted from quali
ComboBox 2- Qualification 2 - info extracted from quali
ComboBox 3 - Qualification 3 - info extracted from quali


RESULT
Employee 1


Employee 2
Employee 3

[ranman256]

I have a convoluted way below (anyone got better?)

0. Put Quals needed in a 'picked' table
1 show all item permutations, clients vs Quals
2. outer join 'All List' to client list to show whats missing (NotValids)
3. ANSWER!: show the opposite of step 2

[June7]

Only 3 qualification factors?

Do you have a table of standard qualifications?

tPickedQuals could be a dynamic parameterized query using IN operator criteria.

SELECT * FROM Qualifications WHERE ID IN(Forms!formname!combo1, Forms!formname!combo2, Forms!formname!combo3);

I've never used dynamic parameterized queries but might make an exception for this requirement.

However, if you want to allow any number of qualifications, use ranman's suggestion for saving records to a temporary table (table is permanent, records are temporary). Only one combobox needed. Or use multi-select listbox and VBA code loops through listbox selections and saves records.