I have an asp page that will take two dates. Then I have a SQL statement that is supposed to pull any events starting on the first date and moving through to the second date. I figured I'd create some kind of loop so that I could change my SQL for each day. Something like this.<BR><BR>startDate = request.form("startDate")<BR>endDate = request.form("endDate")<BR><BR>for i = startDate to endDate<BR>SQL = "SELECT....."<BR>next<BR><BR>My question is that I'm not sure how to save each round through my loop. When I'm done with my loop, I need to have a recordset to work with. So, I figured I should somehow try to use an array, but I wasn't sure if I could store a recordset in an array. Could I do what I've done above something like this?<BR><BR>dim dtArray(7)<BR>for j = 1 to 7<BR>for i = startDate to endDate<BR>SQL = "SELECT....."<BR>set rs = conn.execute(SQL)<BR>dtArray(j) = rs<BR>next<BR><BR>This is the only way I can figure it out, but I don't know if it is valid. If there is a problem with this, does anyone know another way to do what I'm trying to do? Thanks.