Expressions in Sub headers

D

dave.degroot

Hi there, I'm trying to break down a report by division so that every
division (a one to many relationship to suspenses) shows, percentage
of overdue suspense, etc. Currently, this is my expression to show
the percentage overdue of all the divisions (which I put at the top of
my report).

=Int((Sum(IIf([Justified?],[CountOfsuspense_id],0))/
Sum([CountOfsuspense_id]))*100)


What I'd like to do is put this expression based on the
"division_name" into my division name header and therefore show the
percentage for each division.

Is there a way to do that?

Thanks!

David
 
D

dave.degroot

Hi there, I'm trying to break down a report by division so that every
division (a one to many relationship to suspenses) shows, percentage
of overdue suspense, etc. Currently, this is my expression to show
the percentage overdue of all the divisions (which I put at the top of
my report).

=Int((Sum(IIf([Justified?],[CountOfsuspense_id],0))/
Sum([CountOfsuspense_id]))*100)

What I'd like to do is put this expression based on the
"division_name" into my division name header and therefore show the
percentage for each division.

Is there a way to do that?

Thanks!

David
Click to expand...

nevermind. I guess Access figures this out automatically. I just
dropped the expressions that I had in the header in to the subheader
and the expressions worked. wow.

:)
 
Top