|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
February 12th, 2007, 01:26 AM
posted to microsoft.public.access.queries
|
|||
|
|||
Compare Sets of Data
I have a list of products that have multiple features. Some optional some
manditory. I'd like to compare my table of products and features with a reference table of products & the manditory features and show the list of products that are missing the manditory features. tblProducts tblProductsRef Prod_ID Prod_ID Features_ID Features_ID Many Thanks!!! 
|
|
#2
February 12th, 2007, 04:48 AM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Compare Sets of Data
On Sun, 11 Feb 2007 17:26:00 -0800, David127
wrote: I have a list of products that have multiple features. Some optional some manditory. I'd like to compare my table of products and features with a reference table of products & the manditory features and show the list of products that are missing the manditory features. tblProducts tblProductsRef Prod_ID Prod_ID Features_ID Features_ID Many Thanks!!! Use an Unmatched Query Wizard query; or SELECT tblProjects RIGHT JOIN tblProductsRef ON tblProducts.Prod_ID = tblProductsRef.Prod_ID AND tblProducts.Features_ID = tblProductsRef.Features_ID WHERE tblProducts.Prod_ID IS NULL; John W. Vinson [MVP]
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
