G
Guest
The company has an odd way of summarizing data - their fiscal months start
before or after the actual first day of the month (but always on a Mon). The
number of weeks in a fiscal month vary from 4 to 5. The dates on which a
fiscal month change from one year to another, and every 6th year there will
be an extra week added into December to catch up.
I have a text report that is grouped on months. I created a query that
calculates the start date and end date for each fiscal month. How can I
summarize on those fiscal months in this report? I also have a line graph
which shows tons of product per month. How can I change it from regular
months to fiscal months?
before or after the actual first day of the month (but always on a Mon). The
number of weeks in a fiscal month vary from 4 to 5. The dates on which a
fiscal month change from one year to another, and every 6th year there will
be an extra week added into December to catch up.
I have a text report that is grouped on months. I created a query that
calculates the start date and end date for each fiscal month. How can I
summarize on those fiscal months in this report? I also have a line graph
which shows tons of product per month. How can I change it from regular
months to fiscal months?