Create query of values that do not exist in original table

[jcfraun]

Here's my situation:

I have two tables that have the following structure.

Table 1: Attributes
Fields: RecordID - auto number
HeaderProduct
AttributeName

Table 2: Category
Fields: Altprod
Category

The tables are related by the HeaderProduct and Altprod fields.

What I want is to build a query that gives me the combinations of Category/HeaderProduct/AttributeName that do NOT exist in AttributesFiltered.

My end result will be used in a subform to show me which products in a certain category do not have the selected attribute.

I did achieve this by creating multiple queries, but Access shuts down when I try to use it in my form, so there must be something not quite right with it.

Thanks!

 

[MichaelRed]

Unmatched - query Wizzard




MichaelRed

 

[PHV]

What is AttributesFiltered ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[jcfraun]

Sorry, the table is called AttributesFiltered, not attributes.

Where do I find this unmatched query wizard?

 

[PHV]

combinations of Category/HeaderProduct/AttributeName that do NOT exist in AttributesFiltered
So, which AttributeName ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886