Expressions in Sub headers

  • Thread starter Thread starter dave.degroot
  • Start date Start date
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
 
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.

:)
 
Back
Top