I'm looking for the sql statement to pull a number of rows from a table. I already have a sql statement that pulls a number of unique patient ID values. This then leaves me with a recordset (rs1) with these ID values. Now I want to pull all the data from another table in a different database, where the patient IDs are equal to the ones I have in rs1. Here is what I've got so far: Dim cnn1 As [login to view URL] Dim strQry As String Dim rs1 As [login to view URL] strQry = "Select patientID from Schedule where Date = 'date' & "" Set cnn1 = New [login to view URL] [login to view URL] = g_ADOstrCnn [login to view URL] Set rs1 = GetRecordSet(cnn1, strQry) Set cnn1 = Nothing Set rs1 = Nothing The above works fine. But now I've got this recordset (rs1) that contains some variable number of patientIDs. Now I want to pull into a new recordset (rs2) all the addresses, etc. of each of the patientIDs in rs1. How do I do this? Look forward to seeing your solutions! Jon
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 3) Complete ownership and distribution copyrights to all work purchased.
## Platform
win