counting two fields from different tbls

M

MAC

I have three tbls. Category, ProductsGrp. And products.
tblCategory with CatgoryID and and CategoryName, Tble
ProductsGrp, with GrpID,GrpName,CategoryID and Products
with PrdctID, PrdctName, and GrpID.

I want to make one query to see how many ProductGrp are in
one category (count of ProductsGroup and in the same query
I want to count how many Products (count of products) are
there in same category. I tried this with a summary
query; the first part is giving the right count (ie the
count of product Grp) without adding the tblProducts when
I add the tblProducts and count the product, the product
group count automatically change as product count. (ie
prdctgrp count and prodcts count is same).

The answer should be like:
CategoryName ProductGroup Product
AAAAAAAAA 2 15

I am getting like:

AAAAAAAAAA 15 15

How can I solve this? Or Is this NOT possible to count
both at a time.

mac
 
Top