Retrieve a subset of recordset for further processing

[BenjaminLim]

Hi,

I am trying to retrieve a subset of recordset for further processing.

Code Listing
===============

Set rstd1 = db.OpenRecordset("select Date1 from [First Date Set] order by date1", dbOpenSnapshot)

And I tried using the following to extract a subset from rstd1.

Set rstd2 = db.OpenRecordset("select Date1 from rstd1 order by Date1", dbOpenSnapshot)

=> it didn't work & produce error

And I tried :

Set rstd2 = db.OpenRecordset("select Date1 from [First Date Set] order by date1 where Date1 = rstd1!date1", dbOpenSnapshot)

=> again it failed..

Could you advice? Thanks.

Regards
Benjamin

 

[Psychpt]

exactly what are you trying to do?

 

[BenjaminLim]

From the main recordset I will like to extract a subset of records based on selected date criteria further processing.

Please advice. Thanks.

Benjamin