Access query - Any 3 items from the list specified. (1 Viewer)

ruchika.sachdeva

New member
Local time
Today, 07:33
Joined
Jul 31, 2012
Messages
1
I have 3 tables in my query as item, store and employee. I want to find out a match of any 3 items from the item codes specified in the criteria. The idea is to get the list of employees who sold the combo(combination of any three of the items specified in the criteria). Any suggestions?
 

wilpeter

Canadian enthusiast
Local time
Today, 09:33
Joined
Nov 27, 2009
Messages
211
There's likely a more sophisticated method, but you could start with a query that Counts how many employees have a hit on ItemA OR ItemB OR ItemC. Then use that Query as the source for a Select query that displays just the Employees with a count of >2. Keep in mind some results may have more than 3 but it would depend how many (up to 9 levels of OR) Items you specify.
 

Users who are viewing this thread

Top Bottom