Recordsets

Can anyone tell me how to create a recordset that will append all records from 4 recordsets.

Thank you!