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
|
|||
|
|||
how divide detail by group footer total
i want to divide my detail by my group footer total how
do i do this? is there some way to tell it that im divide by the group footer? |
#2
|
|||
|
|||
how divide detail by group footer total
Dan wrote:
i want to divide my detail by my group footer total how do i do this? is there some way to tell it that im divide by the group footer? If you're using Sum(field) in the group footer to calculate the total, then you can also use it in the group header. The detail section can refer to the group header controls to get the total. -- Marsh MVP [MS Access] |
#3
|
|||
|
|||
how divide detail by group footer total
this is the detail =[CountOfLOANAMT]/[sum of
countofloanamt] and the name is text 23 so in the footer i put =sum([text23]) but it does not work any idea why? -----Original Message----- Dan wrote: i want to divide my detail by my group footer total how do i do this? is there some way to tell it that im divide by the group footer? If you're using Sum(field) in the group footer to calculate the total, then you can also use it in the group header. The detail section can refer to the group header controls to get the total. -- Marsh MVP [MS Access] . |
#4
|
|||
|
|||
how divide detail by group footer total
Dan wrote:
this is the detail =[CountOfLOANAMT]/[sum of countofloanamt] and the name is text 23 so in the footer i put =sum([text23]) but it does not work any idea why? That's a different question than I thought you were asking. The issue here is that the aggregate functions operate on fields in the report's record source table/query. They are unaware of controls in the report. In this case, you should use: =Sum([CountOfLOANAMT]/[sum of countofloanamt]) -- Marsh MVP [MS Access] -----Original Message----- Dan wrote: i want to divide my detail by my group footer total how do i do this? is there some way to tell it that im divide by the group footer? If you're using Sum(field) in the group footer to calculate the total, then you can also use it in the group header. The detail section can refer to the group header controls to get the total. |
Thread Tools | |
Display Modes | |
|
|