I have a sick report which is provided monthly in the format of Excel.
Names down the column and Months across the rows.
However, the months roll over a 13 month period - a new one added to the beginning of the months and the last one dropped off the end.
The data is imported into Access so a report can be produced. The problem I have is that currently I am manually changing the field data source along with the field labels to reflect the roll over.
I am sure there must be a way where I can dynamically changes these - but don't know where to start!
Can anyone please help?
Much appreciated NKA
The answer's always easy - if you know it! ;-)
Names down the column and Months across the rows.
However, the months roll over a 13 month period - a new one added to the beginning of the months and the last one dropped off the end.
The data is imported into Access so a report can be produced. The problem I have is that currently I am manually changing the field data source along with the field labels to reflect the roll over.
I am sure there must be a way where I can dynamically changes these - but don't know where to start!
Can anyone please help?
Much appreciated NKA
The answer's always easy - if you know it! ;-)
