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.