I have been trying to figure out a way to do the following.

I have a table in a database that for simplicity has three columns.

Date 1
Date 2
Quantity

Now when I run a Query I want to pull out all the records in the db where 
Date1 is between two values.  Say I get back 10 results.  A visual 
representation of the data would look like the following:

         05/2002  06/2002  07/2002  08/2002 

05/2002   15

06/2002   20         25

07/2002              30       50             

08/2002              45       60      

09/2002              45       19      20           


For the ordinal combinations where there is a blank, there is no 
coresponding record in the db.

What I want to do is put the quantity values from the recordset object 
into specific ordinals in a 2d array...dynammically.  Any suggestions on 
how to do this.

Thanks

rs.GetRows()

"Michael Miller" <mikemiller991@a...> wrote in message
news:170896@a..._web_howto...
>
> I have been trying to figure out a way to do the following.
>
> I have a table in a database that for simplicity has three columns.
>
> Date 1
> Date 2
> Quantity
>
> Now when I run a Query I want to pull out all the records in the db where
> Date1 is between two values.  Say I get back 10 results.  A visual
> representation of the data would look like the following:
>
>          05/2002  06/2002  07/2002  08/2002
>
> 05/2002   15
>
> 06/2002   20         25
>
> 07/2002              30       50
>
> 08/2002              45       60
>
> 09/2002              45       19      20
>
>
> For the ordinal combinations where there is a blank, there is no
> coresponding record in the db.
>
> What I want to do is put the quantity values from the recordset object
> into specific ordinals in a 2d array...dynammically.  Any suggestions on
> how to do this.
>
> Thanks
>
>