Defining fiscal period month in report page header section

[rgallo01]

1) Creating a report from a Cross tab query for sales by fiscal period where fiscal period does not align with calendar month ends.
2)Each Fiscal Periods is defined as a "Group" (1 thru 6) so cross tab query sort will sort by Group 1 thru 6 (left to right) on the report with each group containing summation of dollars for that fiscal period represented by the group number.
3) Issue is that the report page header needs to display the fiscal period 'month' as "mmm" for each group from the cross tab query
4) I can get the calendar month to display without issue but I need fiscal period month to display.
5) Related cross tab query fields are "Group"; "Dollars"; "Customer", "Period Year", "Period Value"; "Period Start Date"; "Period End Date"

Thanks for your help.

[zmbd]

Well, it appears that you have multiple questions in thread; however, for clarity's sake we ask that each thread be limited to one topic.

So trying to find the main issue in your post, it appears to be the underlying CTQ, which is admittedly one of my week points; however, the following sub-link has some fairly detailed explanations. I've also provided the main link as there is a wealth of information available.

Sub: Crosstab query techniques
Main: Allen Browne's Access Tips

I think once you get the CTQ to fall in-line the rest should too.