Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Apply a new query to an open recordset

Status
Not open for further replies.

flash1

MIS
Feb 19, 2002
11
CA
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 on the based on the first criteria and then apply the next criteria to the first recordset and so on until the initial recordset is filtered a max of 3 times.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top