>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.