I have an SQL query returning its results in a recordset. What i want to do is be able to count how many results there are for a particular field. However I cant find a function in which to do this. What i need is something like RecordSet.Fields("tests").Count which isnt supported. Any ideas?