count record

[Guest urko]

HI all,I'm trying to add # of records per each category /subcategory in my access DB.I have 2 tables in db.1. CategoryADtblcatid ( autonumber )tblSubcatIDtblCategoryName2.ProductstblProdID (autonumber)tblCatidtblSubcatIDtblProductName......Now I was searching the web, but no luck.So If you guys can help me cuz I'm total newbie .Example:1. Category1 (5)....Subcategory1 (3) ....Subcategory2 (2) 2. Category2 (4)....Subcategory1 (2) ....Subcategory2 (2) 3. Category3 (0)....Subcategory1 (0) ....Subcategory2 (0) Now, on default page cateogries are displayed. Each category has around 5 subcategories, which are not visible until you click on the cateogry.For some reason I have problem showing # of records per each category or subcategory.So if any of you know how to help me with this one, I would very much appreciated.