G
Guest
I have a report that I have built from a query that uses four linked excel
tables. The four tables contain current month (Jan), current month-1 (Dec),
current month-2 (Nov), and current month-3 (Oct) performance records. My
report is designed to display current month activity, with the past three
months activity summary displayed as a comparison. I have this set up and it
all works fine. My issue is that I want the month labels to change
automatically for each new month. For example when I run January's report, I
want the current month-1 info to be labeled December, current month-2 to be
labeled November, and so on. It is far too tedious to change these fields
manually on all 12 different reports that I produce each month. I have been
playing with the date functions on the report and I just can't get what I
need done. Does anyone have any suggestions?
tables. The four tables contain current month (Jan), current month-1 (Dec),
current month-2 (Nov), and current month-3 (Oct) performance records. My
report is designed to display current month activity, with the past three
months activity summary displayed as a comparison. I have this set up and it
all works fine. My issue is that I want the month labels to change
automatically for each new month. For example when I run January's report, I
want the current month-1 info to be labeled December, current month-2 to be
labeled November, and so on. It is far too tedious to change these fields
manually on all 12 different reports that I produce each month. I have been
playing with the date functions on the report and I just can't get what I
need done. Does anyone have any suggestions?