By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,984 Members | 2,686 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,984 IT Pros & Developers. It's quick & easy.

Defining fiscal period month in report page header section

P: 1
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.
Jan 7 '14 #1
Share this Question
Share on Google+
1 Reply


zmbd
Expert Mod 5K+
P: 5,397
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.
Jan 9 '14 #2

Post your reply

Sign in to post your reply or Sign up for a free account.