Create a new recordset based on an existing recordset?

[flash1]

I have created a search function that allows the user to select up to 4 different criteria to search the database. I have developed the sql statements. The statements use multiple joins between tables. The various search options make it too complex to apply the criteria using a single sql statement.

Is it possible to use a recordset based on the first criteria and then filter or create a new recordset by appling the next criteria to the recordset and so on until the initial recordset is filtered a max of 3 times.

Thanks,
Lynn

 

[mikey69]

Provided you can construct select queries, you can do this as many times as you like, using the output of one query as the input of the next.

However, your pproblem sounds as if it could be solved by storing fragments of SQL statements and then concatenating them from a series of click events bound to command buttons.