- First, you cannot add numbers and letters
Code:
IIf([FiscalYear]=[cboFY].[column](0),0)+IIf([FY]="D",0)
I suspect you're trying to concatenate, in which case the operator is the concatenation one (&), not the addition one (+). Saying this because it appears some fields are numeric and some are alpha.
- Not sure why you're using Count. If every IIF returned false, you'd sum a bunch of zeros, so what's to count?
- [] usually denotes a field. I would not use it with the Column property of a combo box.
Aside from those, my usual advice would be to always include the error message and/or number as per my signature below. Otherwise, we're just guessing.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.