Another expression in a control

[Danielle]

My report is sorted and grouped at 4 levels. One of the footer levels is "resource type". There are two resource types that get displayed- contractor and employee. The report displays different total lines each for contractor and employee. My problem is that I need to grab just the contractor total for another control in the next footer. I have tried the following, but it displays nothing:

=IIf([RESOURCE TYPE]="EMPLOYEE",([Sum Of BILLABLE HRS]))

I just want to see the [Sum Of BILLABLE HRS] for employee here.

I need a separate line of totals in the design of the report, one each for employee and contractor, so I can use their results for another control. But I am not sure even what footer to put it in, to get the results.

 

[Deb in LA]

Try this:

=IIf([RESOURCE TYPE]="EMPLOYEE",([Sum Of BILLABLE HRS]),"No Billable Hours")

Iff statements are like saying if this do this else this. Missing the else part could be the problem. Try the above and let me know if it solved your problem.

Deb