Variable Column Headings

[asparks16]

Hello! This is my first post and I hope I can describe my problem clearly. I have created a db to collect information about a product line. Each product has a code that IDs the product type (i.e. cleaner, defoamer). Each product type has sub-categories (application, pH, foam). Since not every sub-category is going to apply to each product type and not all of the fields are of the same data type, I have created generic fields in the product table to store the information and then I have a "headings" table that provides the headings based on the product type. I have several text fields, several numeric fields and several yes/no fields setup in the products table (text1, text2, value1, value2, yesno1, yesno2, etc.) I am trying to write a query that will pull the information together for exporting to an excel spreadsheet. I cannot figure out how to get the assigned "heading" from the heading table to appear as the column heading in the query. Of course, this is dependent upon the product type (ProdLine3_ID), so I have linked the product table and the heading table in the query on that field. I would like the column heading to be a field value from the heading table (i.e. "Form"), but the actual field value to be from the products table (i.e. "liquid" or "powder")

Any suggestions on other ways to configure this are appreciated, as well.



Thanks!

[June7]

Field names in Access query object cannot be dynamically set by a variable.