>Thanks for replying
>It seems that it is storing all the result sets in the recordset object and you need to go through a loop to cycle using NextRecordset
>but What I want exactly is to get the last result only in the recordset object
>not multiple recordsets.
>Your reply is highly appreciated
>Ibrahim
You should not need to use the NextRecordset. Your first select output its result into a temp table and the second select outputs its result.
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com