recordset based on another recordset

  • Thread starter Thread starter Newbie
  • Start date Start date
N

Newbie

Hi,

is it possible to create a recordset from another recordset

eg.

rs1 = records with duplicate stockcodes
rs2 = select distinct stockcodes from rs1

I have the following code but both come up with Type Mismatch

"SELECT DISTINCT StockCode FROM '" & rsGRN & "'"
"SELECT DISTINCT StockCode FROM " & rsGRN

What am I doing wrong

Thanks for any help
 
Back
Top