When using either of these properties on a recordset, is it possible to run various filters/sorts on one query?<BR><BR>for example, say i run "select * from tblname orderby lastname":<BR><BR>i display all the results, and spend the time to actually run the query. now i want to filter all the records where the lastname is &#039;jones&#039;, or the firstname is &#039;john&#039;.<BR><BR>if i use the filter/sort methods then, will i be improving performance at all? i don&#039;t think this makes me run a query again, but the object still has to be created again it seems .. <BR><BR>i&#039;m looking for performance improvements here where i don&#039;t have to rerun the query everytime .. <BR><BR>help .. <BR>