exclusion when generating total

K

Kevin

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!
 
D

Duane Hookom

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.
 
Top