If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
Group Header/Detail Section
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] |
#3
|
|||
|
|||
Group Header/Detail Section
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] |
#4
|
|||
|
|||
Group Header/Detail Section
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] |
Thread Tools | |
Display Modes | |
|
|