Somewhat Difficult (or at least for me) Sum

[pjd71]

Still getting back into the Access world since I retired from the Marine Corps. I have built a database for purchase requests for medical equipment for the VA (current employer). I have 1 table and 1 query that I have made a report for. I have the report grouped by [Cost Code] and sum up the [TOT of REQ] (total dollar amount) by [Approved] (Yes or No), using this expression: =Sum(IIf([Approved]=-1,[Tot of REQ],0)), which works with no issues. Some of these requests have been purchased and the cost was sometimes greater that what was requested. I made a field called [Final Cost of PO] (total amount of the purchase).



What I want to do is have the sum of the group reflect [Approved] [TOT of ReQ] without calculating if there is a dollar value in the [Final Cost of PO].

Any help would greatly be appreciated.

Thanks,
Patrick

[pjd71]

I added a simple "AND" in and it worked. I also tested to make sure.

=Sum(IIf([Funded]=-1 AND [Final Cost of PO]=00,[Tot of REQ],0))

[Parsonshere]

Might try something like this:=Sum(IIf([Approved]=-1 AND IsNull([Final Cost of PO]),[Tot of REQ],0)) Best way is to create an update query though.