Recordsets as Query Sources?

D

David Wetmore

I have a database with a number of M2M relationships, which I have gathered together in a very long query
which I use to build an ADO recordset for one "record". Is there any way I can run queries on that recordset?
I want to remove duplicate entries in specific fields.
 
M

mray29

Are the M2M tables linked into your database? If so, have you considered just
creating a select query in Access, rather than an ADO recordset? Yu could
then use the query as the record source.
 

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

Combine Duplicates in Query 0
Results from a parameter query 3
ADO Parameter Query 2
Update query issue 0
Is it possible to use multiple recordset objects in a query? 1
Normalization woes - how do I reproduce a query? 5
One query for report and Excel 3
Access Query Optimizer error 5

Top