I have a report based on a pivot query that generates data for a chart.
The column heading names in the chart varies, in the report, from one page to the other based on user data.
Access sorts the columns in an alphabetical order.
I know about the "column headings" propery but it is no use to me because my column headings names vary according to the user data.
I want to define the sorting of the columns according to a user defined key related to each column heading.
Example:
key: heading name:
1 head1
3 head2
2 head3
sorting of the column headigs shall be according to the field "KEY" while the heading names can not be known in advance.
Does anyone know of a way to do this?
Please help.
The column heading names in the chart varies, in the report, from one page to the other based on user data.
Access sorts the columns in an alphabetical order.
I know about the "column headings" propery but it is no use to me because my column headings names vary according to the user data.
I want to define the sorting of the columns according to a user defined key related to each column heading.
Example:
key: heading name:
1 head1
3 head2
2 head3
sorting of the column headigs shall be according to the field "KEY" while the heading names can not be known in advance.
Does anyone know of a way to do this?
Please help.
