Is there a way to get a count on just the number of records on TB2 table. I have tried using Count() but I get an error, so I don't think I am using it correctly.

"SELECT TB1.Category_ID, TB1.Category_Name, TB2.Item_ID, TB2.Item_Name " &_
"FROM TB1 " &_
"LEFT JOIN TB2 " &_
"ON TB1.Category_ID = TB2.Category_ID_TB2 " &_
"WHERE TB1.Category_ID = " & strSelectedCategory & " ORDER BY TB2.Item_Name;"

Many Thanks
Mike

__________________
Peace
Mike
http://www.eclecticpixel.com

Hi ,
  The folowing code will help you in this regard.

"SELECT count(distinct TB2.Item_ID) " &_
"FROM TB1 " &_
"LEFT JOIN TB2 " &_
"ON TB1.Category_ID = TB2.Category_ID_TB2 " &_
"WHERE TB1.Category_ID = " & strSelectedCategory & " ORDER BY TB2.Item_Name;"

Thanks
Suresh Babu