Okay, so I know the question is really mixed up right there, but that's not exactly what I mean. I think it will be clearer if I give you the situation.
I have this table T that contains 3 columns. Let's say columns x, y, and z. and I want an application-generated table G where the values under T.x goes as the column header for table G, T.y becomes the row header, and Z the value stored within (x,y). You see, I was planning on making a dynamic table G programmaticall y.
Another comparison is a 2-D array, let's say Z[x][y], where z is contained by a certain point, (x,y).
Example:
Table T...
x y z
b be e
d do o
j ju u
l la a
b ba a
...to Table G
b d j l
a ba ~ ~ la
e be ~ ~ ~
o ~ do ~ ~
u ~ ~ ju ~
I'm really doing a poor explanation on this, but I hope you get what I was trying to achieve. Now the problem I have is, I don't know how to create table G. i have figured that maybe I could use the PIVOT SQL command for MS SQL, but I'm working with VB.net and MS Access (I'm using OLEDB). I have tried it on MS Access but apparently, I still need a VB code because I want to specify a few limitations to the table.
Not only is the creation of tables the problem here, but also updating the tables every time a user wishes to create another column in Table G.
Please help.
I have this table T that contains 3 columns. Let's say columns x, y, and z. and I want an application-generated table G where the values under T.x goes as the column header for table G, T.y becomes the row header, and Z the value stored within (x,y). You see, I was planning on making a dynamic table G programmaticall y.
Another comparison is a 2-D array, let's say Z[x][y], where z is contained by a certain point, (x,y).
Example:
Table T...
x y z
b be e
d do o
j ju u
l la a
b ba a
...to Table G
b d j l
a ba ~ ~ la
e be ~ ~ ~
o ~ do ~ ~
u ~ ~ ju ~
I'm really doing a poor explanation on this, but I hope you get what I was trying to achieve. Now the problem I have is, I don't know how to create table G. i have figured that maybe I could use the PIVOT SQL command for MS SQL, but I'm working with VB.net and MS Access (I'm using OLEDB). I have tried it on MS Access but apparently, I still need a VB code because I want to specify a few limitations to the table.
Not only is the creation of tables the problem here, but also updating the tables every time a user wishes to create another column in Table G.
Please help.