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?

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]

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]
.

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.