Database to identify products sold in county but not in individual account

[carcement]

I'm attempting to create an access database that takes a table of products sold in a county, rank them per county, then compare them to a table of product sold per account to generate a list of the top ten products not sold to an account that are sold in the county along with their ranks. I'm not sure how to achieve this with queries without filtering down to each account and parish individually at the beginning. Ideally, I would be able to create a report that groups by account number and just print the report once each quarter.

Any help is appreciated, an example DB is attached.

[NTC]

well one starts by setting up individual queries that give you the piece parts that you know you need:
[products sold in a county]
[ rank them per county]
[product sold per account]
[accounts by county]

and then join the queries appropriately into a new query where [product sold per account] is null - there is a No Duplicates query wizard that can help you with that one....