Gerate filed names in a query based off of a table

[zxc]

I need to generate field names for a query based off of information from another query. What I have are two tables, one containing the specific information customers require, the other a large table containing the information. I want to generate a table of results based on customer specific requirements. I apologize if this questions has already been answered somewhere else, I tried search for it, but could not find what I am looking for.

[ajetrumpet]

dynamic field creation in a query can only be done through code. you need to create a querydef in the 'currentdb' collection

[zxc]

I was afraid of that, I am very new to the code bit, is there an example out there? I have table 1 "COA req" and table 2 "QA Data" I need the test names that would be specified in a query of COA req to become the fields in a query of QA data.