[AccessD] Using recordset in a query

I am trying to use the following query but am getting no records returned. Can this be done or am I approaching this all wrong?

Set RS1 = MyDb.OpenRecordset(strSql)

strSql = "SELECT dbo_DSS_StatusChanges.PID, RS1.Fields(1), " & _ 	"dbo_DSS_StatusChanges.StatusDate, dbo_DSS_StatusChanges.Status " & _
      "FROM RS1 INNER JOIN dbo_DSS_StatusChanges ON " & _
	"(RS1.Fields(3) = dbo_DSS_StatusChanges.StatusDate) AND " & _ 
	"(RS1.Fields(0)  = dbo_DSS_StatusChanges.PID) " & _
      "GROUP BY dbo_DSS_StatusChanges.PID, RS1.Fields(1), " & _ 	"dbo_DSS_StatusChanges.StatusDate, dbo_DSS_StatusChanges.Status;"

Chester Kaup
Engineering Technician
Kinder Morgan CO2 Company, LLP
Office (432) 688-3797
FAX (432) 688-3799

 
No trees were killed in the sending of this message. However a large number of electrons were terribly inconvenienced.