Multiple column headings in Access 22 May 2015 - 17:23

I do a lot of data processing and reporting where the data is extracted using an Access cross-tab query... I used to find it irritating that in Excel you can of course arrange your column headings as you wish, with multiple levels of headings, but in an Access cross-tab query you can only have one set of column headings...

To increase the number of fields used for column headings, go into design view, and instead of selecting a field for the column heading, type in an expression. For example the expression

[ThisField] & " - " & [AnotherField]

will group the data by both fields (and display the column heading with the values split by a hyphen, for readability). Result - less copying and pasting required to fit the data into the spreadsheet :-)