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

Question

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?

Answer 1

Try this:

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