Sum Question

[Sum Question]

I have a tabular report based on a query that retrieves
employee data per department, including Name, Hrs/Week,
Rate of Pay, etc.

And I have used =Sum(Abs([Name - Full] Like "OPEN
POSITION*")) to get a count total open positions (Each
Open Position Appears as an Employee with a "name" that
starts with "OPEN POSITION"). I would like to get a sum
the Hrs/Week that correspond to the open postions (Sum of
total open weekly hours). Is there a way to do this in
the report without linking the control to a query?

Thanks in advance.

 

[Duane Hookom]

Try
=Sum(Abs([Name - Full] Like "OPEN POSITION*") * [TotalOpenHrs/Week])

 

[Bill]

Your formula =Sum(Abs([Procedure] like "Yes")) solved a
problem I have been wresling with for some time.
I have 10 columns of 10 different procedures and 10 rows
of doctor names. the columns have Yes or No either the MD
did the procedure or not. the formula allowed me to count
the Yes's by procedure by the grouping of MD with the
total of each procedure at the end of each group . Then by
hidding the detail section I got a very nice summary
report.
Thanks