Query that provides combination of data that meet a certain criteria

Only to repeat what I said:

1) CREATE TABLE statements for your tables.

2) INSERT statements with sample data.

3) The desired result given the sample.

4) Which version of your software product you are using.

With this it is possible to copy and paste into a query window to develop a tested solution. From what you have posted this far, I would only be able to provide guesses. Now, since you have told me that you are using a different product, I will not even try.

Of course, in an Access forum they have a different culture from what they expect. But the whole idea is of the list is that you help us helping you by doing all the boring work for us.

---

Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se