Create one DAO.Recordset from several

  • Thread starter Thread starter Kristian
  • Start date Start date
K

Kristian

Hello,
Is there a fast way to create a large recordset
from several or do I have to loop through each recordset?
I create one recordset from each selected mdb in a list
box and want to combine those "part recordsets" to a
"total recordset" consisting of all the records from each
one.

Grateful for any tip!
Regards,
Kristian
 
Perhaps creating a Recordset based on a UNION Query which combines Records
from different Tables.

Check Access Help / JET SQL Reference on the UNION Query.
 
Back
Top