[AccessD] Using recordset in a query

Mark A Matte markamatte at hotmail.com
Thu Apr 9 08:43:44 CDT 2009


Chester,
 
Was curious if this was solved?...and what direction you went.
 
Thanks,
 
Mark

----------------------------------------
> From: Chester_Kaup at kindermorgan.com
> To: accessd at databaseadvisors.com
> Date: Mon, 6 Apr 2009 15:03:05 -0500
> Subject: [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.
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
_________________________________________________________________
Rediscover Hotmail®: Get quick friend updates right in your inbox. 
http://windowslive.com/RediscoverHotmail?ocid=TXT_TAGLM_WL_HM_Rediscover_Updates1_042009



More information about the AccessD mailing list