Object reference not set to an instance of an object. SELECT [ClassifiedCategory].[Category], Count([Classifieds].[CategoryID]) AS CountOfCategoryID, [ClassifiedCategory].[CategoryID] FROM Classifieds RIGHT JOIN ClassifiedCategory ON [Classifieds].[CategoryID]=[ClassifiedCategory].[CategoryID] GROUP BY [ClassifiedCategory].[Category], [ClassifiedCategory].[CategoryID] ORDER BY ClassifiedCategory.CategoryID;Object reference not set to an instance of an object. Select * From Classifieds Where CategoryID=1 AND Post=-1 Order by AddedDate Desc;