help - filtering reprt footer sum based on detail section values

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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. ;-)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

store a value of a text box that calculates data into a data sourc 2
Total in report footer 1
Making a calculation in report footer of every record 1
Form Detail Sum 5
Wrong Sum in Report Footer 2
Percentages in Reports 3
Trying to Count in a Report 3
Running sum on report 4

Back
Top