Cross tab query for 3 month per report

[wannabepro]

I am trying to create a cross tab query which will output the data for only three months starting from the recent month. I would want these months to be heading. However, I don't want to create reports over and over again. I want something, that will resolve the issue through parameters kinda thing. I don't know, if this can be done or not. Right now I have the cross tab query for all the months, but I have to manually choose the months to fit in the page. I hope I am making sense here. I didn't know where to post this, in query or in report. Therefore, I am posting it here.

Thanx in adv.

 

[wannabepro]

Pat Hartman, I looked for it but I still don't know what I am suppose to do. I do have a query right now that actually prints out the records for all 12 months. However, I just want it to display the records of current months and also two coming up months. I don't want to see the previous records. And I want the month names and year to be header. I am still searching for help.

 

[wannabepro]

Thank you so much pat hartman, I think I am coming along now just fine. Much appreciate your help

 

[wannabepro]

but I have a lil tiny prob too, sorry I know I am taking a lot of ur time. I just want to know, if I want the sum of each month how can i get that, I can get it through simple query by each month, but instead of vertically, I want this to be horizontally, like cross tab.

And by using the ur given example, I broke the 3 months in different report so the user can select date between those three months. And its working fine. But can I also have the total at the bottom, and the start date and end date wont pop up again.

 

[wannabepro]

I don't understand the question. The crosstab gives you a row total so that would be the sum of all months shown.

No. Queries can only show a single level of summary at a time. If you want groupings and grand totals, you'll need to make a report.

Thanks Pat Hartman, actually, I just had to sum it up in the report bottom. And instead of doing it Report Footer, I was doing it in Page footer. And, thats what cause the prob, but now everything is fine. Thank you again