Ms Access Crosstab Report with variable number of columns
Posted on 2014-02-21
I have a crosstab query that I want to place in a report.
The issue is that the query result will have a variable number of columns .. from 3 to 15. I have seen the code MS has provided for crosstab reports, but for my case either I have a large amount of blank space in the report or I get a runtime error beacuse I have more columns than textboxes.
Anyone have a better approach for this, or a better solution than the MS code?
Thanks in advance.