RushiShroff
Programmer
Hellow all,
I am stuck here while making (Check it out !)
DataBase : MS-Access 97
On the home page, I want to list out all main categories from Categories table.My classified offers lie in Classified table.
I have to list out all categories even if there are no offers for it.I mean if some category has no offer,in bracket it should show (0).
To achieve the count for all categoies, I create a query which has a relationship Cat_Code common in both the tables.Then I am counting the number of each category.So I know the total no of offers in that.
But this doesnt include those categories which are not there in classified table.So categories having no offers are not coming into picture.
Can anybody tell me how to get the count of all categories from
Classified table..??
Please,
Rushi Shroff
I am stuck here while making (Check it out !)
DataBase : MS-Access 97
On the home page, I want to list out all main categories from Categories table.My classified offers lie in Classified table.
I have to list out all categories even if there are no offers for it.I mean if some category has no offer,in bracket it should show (0).
To achieve the count for all categoies, I create a query which has a relationship Cat_Code common in both the tables.Then I am counting the number of each category.So I know the total no of offers in that.
But this doesnt include those categories which are not there in classified table.So categories having no offers are not coming into picture.
Can anybody tell me how to get the count of all categories from
Classified table..??
Please,
Rushi Shroff