I have created an Access crosstab query - where the column headers are month/year. In properties - column headings - I have manually entered the order I want mm/yyyy to appear since this is a text field.
The intent is to make this automated, so someone other than me can use this as well.
Therefore, in column headings I have entered values that may not be on the current crosstab output, but are included for future reports.
Unfortunately, the empty future columns appear as well.
Is there a way to limit the columns to those that have matching data values (and not all the column header values) when running the crosstab query output.