Query Combo Boxes (100+) to Produce Listing of Unchecked Box Names

[petersonm]

There are 102 counties in Illinois. I have a county table [tblCounty] that lists those counties under the column "County", which also has a column "Number" that numbers them 001 to 102. There is a separate table [tblTitleToTitleCode] that lists sales categories by sales category code (two columns).

Another table has customer number, sales category, and region. In this table, the customer code is a combo box from the [tblTitleToTitleCode]. The region is a combo box from the [tblCounty]. I need to produce a query that list those counties by name that do not have a sales category. Those are the counties that are not receiving sales marketing for specific sales categories, which means we have the ability to increase sales through surgical marketing.



I'm open to any and all thoughts, but consider me unskilled at Access.

County	Number
Adams	001
Alexander	002
Bond	003
Boone	004

Title Code	Title
04100	Baker
04250	Barber
04350	Beautician

Customer	SalesCategory	Region
790-1	06650	Adams, Alexander
195	06650	Calhoun, Carroll, Cass

Thanks for your assistance - Pete.

[isladogs]

You need an unmatched query (a wizard is available) joining tblCounty to tblTitleToTitleCode linking with a common field and using an outer join
The problem I have is that from your description there doesn't seem to be a common field in both tables
Without that you're stuck ...unless your third table provides a linking field

[ssanfu]

Using your current table designs, it will be difficult, if not impossible, to get your answer.
You should NEVER use look up FIELDS, nor MVFs in tables. And Microsoft never fully implemented MVFs in Access.
No other dB uses Look up Fields/MVFs.

I have a county table [tblCounty] that lists those counties under the column "County", which also has a column "Number"

OK, got it.

There is a separate table [tblTitleToTitleCode] that lists sales categories by sales category code (two columns)

OK, Got it.

Another table has customer number, sales category, and region.
In this table, the customer code is a combo box from the [tblTitleToTitleCode].

Whaaaattt???? The customer code is a combo box from the [tblTitleToTitleCode]??? But [tblTitleToTitleCode] is Sales Category....


I gotta stop. My head hurts.......

Maybe post your dB or images of your relationship window?