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.
 
Top