Can Anyone help
Akin to the excel transform action when pasting special in excel, is there such an option to do this in Access. I have heard that there is a Transform Query that can do this
As an example I have 10 entries in a table with a column called building. the entries are London A, London B, London C and so on
I would like to convert them so the column headings as a result of a query become London A, London B etc
Many thanks in anticipation of any help
Akin to the excel transform action when pasting special in excel, is there such an option to do this in Access. I have heard that there is a Transform Query that can do this
As an example I have 10 entries in a table with a column called building. the entries are London A, London B, London C and so on
I would like to convert them so the column headings as a result of a query become London A, London B etc
Many thanks in anticipation of any help
