exclusion when generating total

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

Guest

I have a report that totals labor hours for a that are, categorized by
records in a field called CBDcode. Some of the available records in CBDcode
are: Engineering, Manufacturing, Custom, Finishing...

I have a control in the CBDcode footer wich gives the total hours per
category, and then in the report footer I have a control (same expression)
which gives the overall total. That expression is: =Sum([LineTotalLabor])

I would like to show the total labor from everything BUT those records with
"Engineering" hours. Can the expression be modified to accomplish this?
Thank you in advance for any help!
 
The simple, hard-coded method is to create a text box with a control source
of:
=Sum(Abs(CDBCode<>"Engineering") * [LineTotalLabor])

A more robust solution would be to add a field in you CBDcode table that
identifies whether or not to include the code in specific calculations.
 
Back
Top