Dynamically assign fields in a query

[Eurof]

I am not aure if this is a simple or difficuly question, but here goes.

I have two tables. Table A has 16 columns, and table B has 3. I then want to query on different columns on Table A depending on the column numbers stored in table B.


So looking at the attached document, you can see that for ImportTable = tblImport14 I would like to return a query with columns 1,3,4,15,14,10,7 and 7

Any ideas, ?? assuming that it is understood?

 

[Eurof]

Oops I think I got the attachment wrong.