Archives of the TeradataForum

Message Posted: Thu, 26 Sep 2002 @ 12:02:09 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Raz:

What you need to execute at the end of the first recordset is:

Set yourrecordset = yourrecordset.NextRecordSet

Obviously, you will require an inner loop to traverse the actual rows and an outer one to traverse the recordsets in the macro until yourrecord is Nothing.

God Luck

Jim Calvert - NCR

	<Prev	Next>		<<First	<Prev	Next>	Last>>