J
Justin A
I have a database which esentially stores contracted staff inputs (days) for
the coming 12 months against each month (ie we have this much work for this
person to do in this month etc etc). The principal table uses dummy column
headers 'M1', 'M2' etc so that we don't have to keep re-defining forms and
reports as the months change. I was shown how to add some VB to over-right
the field captions in reports to show the actual months - [M1 Label].Caption
= Format$(DateSerial(theYear, theMonth, 1), "mmm yy") etc etc - using data
stored in another table.
I have just succeeded in getting MS Access to present data in a query as a
stacked bar chart. What I'm wondering is whether I can use a similar trick on
the chart to overwrite the x-axis labels. Is there something I can do in the
query builder? Or do I need more VB code? I would like the process to be
automatic and I'm hoping not to have to resort to producing my charts in
excel...
the coming 12 months against each month (ie we have this much work for this
person to do in this month etc etc). The principal table uses dummy column
headers 'M1', 'M2' etc so that we don't have to keep re-defining forms and
reports as the months change. I was shown how to add some VB to over-right
the field captions in reports to show the actual months - [M1 Label].Caption
= Format$(DateSerial(theYear, theMonth, 1), "mmm yy") etc etc - using data
stored in another table.
I have just succeeded in getting MS Access to present data in a query as a
stacked bar chart. What I'm wondering is whether I can use a similar trick on
the chart to overwrite the x-axis labels. Is there something I can do in the
query builder? Or do I need more VB code? I would like the process to be
automatic and I'm hoping not to have to resort to producing my charts in
excel...