Chart from previous period

  • Thread starter Thread starter Robbie Doo
  • Start date Start date
R

Robbie Doo

I created a report with 2 pie charts. One showing the chart for the current 6
month period and the other the previous 6 month period. However, our 6 month
periods are set from Apr-Sep and Oct-Mar (which is a separate table listing
all the periods every year). Everyone month we have a meeting on a certain
day (usually middle of the month). I run the current chart accroding to the
Meeting Date and the previous chart is pulled with DateDiff of 6 months from
that date.

I was just wondering if it is possible to pull the previous 6 month chart
using the Previous Period instead of DateDiff of 6 months from the Meeting
Date?

If this wasn't enough information to go by please let me know. Thanx
 
It is very possible. Store the current and previous period start dates in a
table, then use those values for the query.
 
Back
Top