help - filtering reprt footer sum based on detail section values

J

jkendrick75

need help with this.

i have a text box (TotalPressHours) in the report footer section that sums
the hours that all presses ran for a shift. its recordsource is
'=Sum(UpTime)'. this sum is the sum of a text box in the details section
(ActualHoursRan) whose recordsource is 'UpTime'. I need the TotalPressHours
to only add the uptime values where another text box in the details section
has a value of '0'. (as some presses can be running a left and right hand
part, we don't want the number of hours the press ran to be doubled)

any help with this would be appreciated and thanks in advance.
 
J

jkendrick75

well, once again, i'm able to figure out how to solve the problem, the day
after i ask for help... oh well, thanks to anyone who looked at my question
and tried to work on a response. ;-)
 
Top