It would help if you'd provide the real error message, and some code that causes the error.

Anyway, an EOF error is probably good. This means that the object returned from the array is indeed a recordset. So, all you need to do is check for EOF before you call MoveNext or MoveFirst.

Why do you need 11 recordsets in an array? Can't you execute 11 separate statements, or combine a few queries?

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004

Hi Imar
thank you for your Reply.I think if i explain what should i do it whould be better:
this is a project that has 11 type units.and each unit has some parts(about 200 part in each).I saved these parts for these 11 units and the way they should be in a table called a for example

these 11 type of units are 50 units in quantity.It means i have 50 unit with 11 different types.I saved the actual values of these 50 units in a table called b for example

and these units have date to finish that is saved in a table called c

I want to have 11 recordset for each of those 11 type of unit that contains the way that these units should be and the actual for calculating the delay of each part.

because of this i creat 11 recordset that inner join a and b with the part names and then innerjoin them with c with the unit numbers not unit types(because i should have the delay of each unit number)
that's the thing i should make .i hope I complained it in a way that I can get your helps.excuse me if i take you time so much
thank you for your helps

It must be me, but I have no idea what you're talking about.... ;)

Can't you just execute each recordset when you need it? Why do you need to store all this stuff in an array?

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004