Summing Certain Values in a Report 1

[dmlatham]

I am currently trying to create a report that only sums certain values. For instance (please note the totals with a * preceding),

Trial
Personal 6
Joint 4
Never Handled 8

* Personal and Joint Total 10
Trial Total 18

App Memo
Personal 5
Never Handled 6

* Personal and Joint Total 5
Trial Total 11

Cert Memo
Never Handled 6

* Personal and Joint Total 0
Trial Total 6

----

I would like to be able to sum up the "Personal and Joint Total". I have tried the following:

=IIf(([handling_desc]="Personal" And [handling_desc]="Joint&quot,Sum([fy1hours_both]),(IIf([handling_desc]="Personal" Or [handling_desc]="Joint",[fy1hours_both],"0&quot))

I only the sum of the "Personal" instead of both when there is also a "Joint". So basically if I applied the above code the the above report example, my results for "Personal and Joint Total" will be 6,5 and 0 respectively.

Any and all help is greatly appreciated.

Deborah

 

[kellykindopp]

hope this helps, I only see the need for 1 iif , hope I am reading your Prob right try this expression


=IIf([handling_desc]="Personal" Or [handling_desc] = "Joint",sum([fy1hours_both]),"0&quot

 

[dmlatham]

Thanks Kelly for the info.

I have implemented the above code in a table for a column named PJ_FY1hours and it works fine. I just wanted to be able to do it directly on the form. If I apply the above code to a text box on the form it does not sum up the correct values. Again Thanks..

Deb