IDEAS WELCOME!

I am in a bit of trouble here, I am trying to figure out a way to solve this problem, If you can think a way please let me know! PLEASE!.<br><br>I am going to simplify things a bit to make it easier to understand:<br>basically what I have is a table, made of 10 columns and 100 records. <br><br>For the first record the columns are numbered 1 to 10, then the first column for all the records are numbered secuentially 1, 2, 3...<br><br>so basically something like this:<br><br>1 2 3 4 5 6...<br>2<br>3<br>4<br>5<br>.<br>.<br> <br><br>the value for each of the empty cells comes from a query with 2 variables on it which are the column and index value<br><br><br>example:<br><br>1 2 3 4 5 6 ....<br>2<br>3 X<br>4<br>5<br><br>lets say where the x is; the query will be something like this:<br><br>select * from table where (foo=4 AND bar=3)<br><br>HERE COMES THE PROBLEM:<br><br>AM I supposed to create (100 * 10 = 1000) queries???<br>I am sure (well, I hope) there most be a more efficient way of doing this.<br><br>PLEASE HELP ME IF YOU CAN<br><br>Cheers!<br><br>Johnnie Walker