Group Header/Detail Section

I have a date field in a table which I need to group on in a report. The
report is setup in columns on a landscape page. In the header section set to
group on the date field I have setup the control to relect if the dates are
between x and y print January, if the dates are between p and q print
February, etc. However, for each date in each month, the header is printed,
i.e., if there are 3 records for 21 Jan, JAN is printed with the three
records, followed by 22 Jan and how many records appear for that. I need each
month printed once and all records within the timeframe to follow.

I moved the control to the Details section and set the Show Duplicates
property to NO. Now I can get Janury to follow with all the records but it is
taking up too much space, i.e, the space for each month appears above each
record.

Any ideas to decrease the number of pages which will be printed?

Thanks.

Danu wrote:

I have a date field in a table which I need to group on in a report. The
report is setup in columns on a landscape page. In the header section set to
group on the date field I have setup the control to relect if the dates are
between x and y print January, if the dates are between p and q print
February, etc. However, for each date in each month, the header is printed,
i.e., if there are 3 records for 21 Jan, JAN is printed with the three
records, followed by 22 Jan and how many records appear for that. I need each
month printed once and all records within the timeframe to follow.

I moved the control to the Details section and set the Show Duplicates
property to NO. Now I can get Janury to follow with all the records but it is
taking up too much space, i.e, the space for each month appears above each
record.


You need to group on your expression that determines the
month, not on each date.

If you were using calandar months, you could group on the
expression =Format(datefield, "yyyymm")

--
Marsh
MVP [MS Access]

Hi -

I am using fiscal months. Newbie here so please be patient. Wouldn't my
expression be "Between 1/15/2007 and 2/14/2007"?

"Marshall Barton" wrote:

Danu wrote:

I have a date field in a table which I need to group on in a report. The
report is setup in columns on a landscape page. In the header section set to
group on the date field I have setup the control to relect if the dates are
between x and y print January, if the dates are between p and q print
February, etc. However, for each date in each month, the header is printed,
i.e., if there are 3 records for 21 Jan, JAN is printed with the three
records, followed by 22 Jan and how many records appear for that. I need each
month printed once and all records within the timeframe to follow.

I moved the control to the Details section and set the Show Duplicates
property to NO. Now I can get Janury to follow with all the records but it is
taking up too much space, i.e, the space for each month appears above each
record.


You need to group on your expression that determines the
month, not on each date.

If you were using calandar months, you could group on the
expression =Format(datefield, "yyyymm")

--
Marsh
MVP [MS Access]

Danu wrote:
I am using fiscal months. Newbie here so please be patient. Wouldn't my
expression be "Between 1/15/2007 and 2/14/2007"?


No. That would be ok as a criteria to select records for
fiscal January, but it won't work for grouping fiscal
months.

Instead, try a Sorting and Grouping expression like:

=Format(datefield - 14, "yyyymm")

and in the group header text boxm use the control source
expression:

=Format(datefield - 14, "mmmm")

--
Marsh
MVP [MS Access]