With fox pro working with tables allows the utilization of a count statement to found out how many of something ='s a certain value. Such as this statment

count for myfield='X' to m.myfield

I am working with ASP currently and connecting to fox pro table using odbc. Is there a way to count a field name = to a certain value like above in my recordset created with ADO?


Thanks in advace.