Need help on displaying data

[Lynsey]

Does anyone know how you would go about this:

In a table1 I have two variables, variable1 and variable2 which relate to a row (variable1) and colum (variable2) in another table.

I want to be able to use the two variables in table1 to crossreference table2 to find the value in position (variable1,variable2) and display that

Any suggestions would be great ....

 

[Lynsey]

to answer my own question you perform a union query for each column name. However, if like me you want to update a table with fixed columns relating to a query where the columns can be dynamic I still can't figure out a solution.