Define column headings based on data in another table

[John@backacre.co.uk]

I want column headings eventually to use in a data collection email. The headings required are a combination of Event_Name, Day_of_week and Date_of_Event, quite a mouthful. This text string I get with a standard query based on a table containing just the event name and dates for each of the days, probably 20 in all, and is easily filled in by the event organiser. I have tried to use VBA to generate a new table with these column headings by looping through a query to get the text string, and then passing the string to various methods of adding fields to a table, all of which fail because they place the name of the variable rather than its contents as the column header. I've been stuck on this for a couple of days now and my head hurts! Getting the organiser to make the column headings each year is a mistake waiting to happen, so I have to avoid it.

 

[highandwild]

Can you send in the SQL command as it may be that you are treating the
variable as part of the literal string and not using the content of the variable.