summs-access-2007where-clauseiifms-access-reports

Sum() using IIF() or Where Clause in MS Access

In my Report: BID is Billing Customer ID a TEXT FIELD. NPROFIT is Net Profit a NUMERIC FIELD.

My Query sums NPROFIT for all BID. Using the statement: =Sum([NPROFIT])

I need to sum the NProfit column ONLY for certain BID values ... ACTUALLY, I WANT TO SUM() 4 OF 10 BID and exclude the other 6 of 10

I have tried: IIF([BID]=403490, =Sum([NPROFIT]), "None")

That does not work. Any suggestions?

Solution

  • Try this:

    Sum(IIf([BID]=403490, [NPROFIT], 0))