I have used a Make Table query to create a new table from data within another table, the Field names in this new table need to be different and will be dependent on original values used for the make table query (all of which are stored in another table).
Am I correct that specifying new Field names with anything other than a plain text value is not possible (e.g. using values from another table is not possible), when using a query?
I presume I would need to use a VBA method to rename the fields in the new table, using a form of lookup (to another table) for the values I require?