I am looping through a recordset. Each time I loop though iot I open up a table and to get some info from it.<BR><BR>Here is my dilemma ....<BR><BR>I need two things from the table. <BR><BR>(1) I need to filter the table based on a vlaue ... this will return one record. In that record I will get the fied value I need.<BR>(2) I need to filter the table based on another value. This will return MULTIPLE records. I need to get the number of records it returns (obj.recordcount).<BR><BR>Is there any way I can get both these things WITHOUT closing the table and opening again or must I do that?