Thanks,

I guess I'll try looping through one recordset and looking up records in another recordset. Unfortunately there are a few recordsets needed in the joins so it will be a bit of work.

I did initially have a temp table in the database and filled this with data. This works, but it does mean that the Access database grows until a compact is done. I would like to move away from Access as the database and I will in the future, but I have no choice in the matter at the moment.

Pete

>Hi Peter.
>
>There's no way to do this, at least that I've come across. I've been faced with similar situations and I have gotten the data I need from the second table, then added the table's fields to the memory-only ADO recordset, then looped through the two recordsets to add the appropriate data.
>
>This requires a design that includes as little data as possible being returned from the data source, of course...
>
>I have also seem folks create temp tables and dump the memory-only rs into the table, and *then* execute a select. And then, of course, clean everything up. Pretty inelegant, but it works.