Query to look for unused data

  • Thread starter Russ via AccessMonster.com
  • Start date
R

Russ via AccessMonster.com

I have a product table "tblProducts" with field named "productcatID" that is
linked to the "tblCategories" via the category id, how can I make a query to
search the products table looking for any unused categories listed in the
"tblCategories"so I can delete any unused categories in the "tblCategories" .


i.e. if the category "Widget" have never been used in the "tblProducts" then
I can delete it

Hope I have explained this well enough...
 
M

Marshall Barton

Russ said:
I have a product table "tblProducts" with field named "productcatID" that is
linked to the "tblCategories" via the category id, how can I make a query to
search the products table looking for any unused categories listed in the
"tblCategories"so I can delete any unused categories in the "tblCategories" .


i.e. if the category "Widget" have never been used in the "tblProducts" then
I can delete it
Click to expand...


Try using the Unmatched quiery wizard.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel - Wich Function should I use? 1
Row Source for Combo Box 2
Many-to-many relationship query question... 2
Crating User Form to Add Names 1
Show only unique records in duplicated field 5
Publisher is filling blank lines with data 2
Unable to display values in 2nd list box from 1st list box selection 2
Newbie -Selecting a DISTINCT 2 fields out of 3? 4

Top