Recordsets as Query Sources?

  • Thread starter Thread starter David Wetmore
  • Start date Start date
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.
 
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.
 
Back
Top