Is it possible to create a report based on a crosstab query that has dynamic columns and column headings?
I've set up a form where the user can select Quarters (for columns) and Cities (for rows). Since the Quarters are chosen on the fly, there's no way to know ahead of time which will appear on the report.
Do I want to have unbound controls that get filled by vba?
At present, my report works fine with 4 Quarters predefined; the user can choose any or all 4. But I want to keep adding more Quarters to the combobox as time passes...
Thanks!
I've set up a form where the user can select Quarters (for columns) and Cities (for rows). Since the Quarters are chosen on the fly, there's no way to know ahead of time which will appear on the report.
Do I want to have unbound controls that get filled by vba?
At present, my report works fine with 4 Quarters predefined; the user can choose any or all 4. But I want to keep adding more Quarters to the combobox as time passes...
Thanks!
