recordset based on another recordset

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

query on query 1
VBA concatenate ranges into a new document 0
Dim rs As DAO.Recordset Error 1
On Change Update Subform 1
"Object doesn't support this property or method" Error on Tree Con 0
Pass Recordset object between subs/functions 6
ADO find method 1
SQL Select in VBA to Open Recordset 2

Top