Query - Help!!

  • Thread starter Thread starter Karen C
  • Start date Start date
Hi,


You can't, as a recordset. You can build a SQL statement, as a string,
getting values of the recordset embedded in the string of the statement, but
a recordset being in a level of existence farter away from the data than the
SQL statement, a direct exchange route is not really supplied.

With DAO, you can open a recordset based on a recordset.

rst1.Filter = .... ' a WHERE clause
Set rst2=rst1.OpenRecordset()


so the end effect is like adding a SQL where clause to the initial
recordset, and get the result in a recordset.

Hoping it may help,
Vanderghast, Access MVP
 
Thank you!!
-----Original Message-----
Hi,


You can't, as a recordset. You can build a SQL statement, as a string,
getting values of the recordset embedded in the string of the statement, but
a recordset being in a level of existence farter away from the data than the
SQL statement, a direct exchange route is not really supplied.

With DAO, you can open a recordset based on a recordset.

rst1.Filter = .... ' a WHERE clause
Set rst2=rst1.OpenRecordset()


so the end effect is like adding a SQL where clause to the initial
recordset, and get the result in a recordset.

Hoping it may help,
Vanderghast, Access MVP





.
Click to expand...
 
Back
Top