how divide detail by group footer total

  • Thread starter Thread starter Dan
  • Start date Start date
D

Dan

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?
 
Dan said:
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?
Click to expand...


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.
 
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?
 
Dan said:
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?
Click to expand...

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]


 
Back
Top