I am trying to count votes and I need a field counted. This works perfect in the mssql query analyser, but I would like to use this feature in my asp page. Here is easy sample.<BR><BR>SELECT count(column_name)<BR>FROM table1<BR><BR>Then in the asp page I tried a simple<BR><BR><%=objRS("column_name")%>. <BR><BR>I Don't get an error on the select statement but once I try to refrenece it, I do. I really can't use objRS.RecordCount. Any idea how to simulate what this does in t-sql into asp?