classic asp query a recordset rather than a table - Stack Overflow

You can use the Clone method to create a duplicate recordset, then use Filter to reduce the dataset to what you're interested in. For example:

stackoverflow.com