Pick the month based on crosstab

[Sohaila Taravati]

I have a report that runs Quarterly and is based on a crosstab query. I have some calculations that are related to the month of January, February and March. I don't want to creat 4 seporate report for each quater. Is it possible to use the same report and try to hide the first 3 months and show the next 3 months and still be able to do the calculations. I have all the months set up in my crosstab query.
Thank you in advance,
Sohaila

 

[Rich]

Create a query that does the calculations prior to the date you want the crosstab to start from.