Crosstab Headings / Dates

  • Thread starter Thread starter Catcher
  • Start date Start date
C

Catcher

I have a crosstab query that has year as row heading and month in the column
heading as represented below. My selected date range includes 2006, 7 and 8
and results in each year with a separate row in the query and "Month 1"
through "Month 12" as the columns:

Expression in the Query Field is;
Expr1: "Month " & DatePart("m",[Order Date],1,0)
Properties:
"Month 1","Month 2","Month 3","Month 4","Month 5","Month 6","Month 7","Month
8","Month 9","Month 10","Month 11","Month 12"

In addition to liminating the year as a row heading, what do I need in the
field and the properties to return all on a single row with column headings
"Jan 06" (or anything close indicitive of Month / Year) through the most
recent month for which my query has data? Thanks!
 
In your report, you will need to use the Sorting 'n' Grouping dialog to
create a Group Header for the year. You can then place 12 text boxes in this
group header to act as the heading names over your 12 columns.

The first text box will always be January, so you can use a Control Source
of:
="Jan " & [MyYear]
substituting the name of the field that actually contains the year.
Same for the other columns.

If you want this heading to appear at the top of the next page when a year
flows over onto the next page, set the group header's Repeat Section
property to Yes.
 
Back
Top