Access query question
First off I'll post a screenshot of the database relationships:
In short, Category contains subCategories which contains Products.
What I want to do is create a query that will list the CategoryName along with the total number of Products associated with that Category (through the SubCategory). I'm not sure how to do this. When I just add the Product table to the query in design view I get a join error. Can anyone point me in the right direction?
In short, Category contains subCategories which contains Products.
What I want to do is create a query that will list the CategoryName along with the total number of Products associated with that Category (through the SubCategory). I'm not sure how to do this. When I just add the Product table to the query in design view I get a join error. Can anyone point me in the right direction?
