I'm stuck.
In the detail section of my report. I have two fields, Revenue & Hours. In
the footer section I want to divide the sum of the Revenue field by the sum
of the Hours field and display the results in another box. What would be the
expresion for that?
Here is what I am doing but I can't get the sum of hours.
=sum([Revenue])/[Hours]
Duane Hookom - 13 Dec 2005 22:12 GMT
=sum([Revenue])/Sum([Hours])

Signature
Duane Hookom
MS Access MVP
--
> I'm stuck.
>
[quoted text clipped - 8 lines]
>
> =sum([Revenue])/[Hours]