Microsoft Access 2010 IIF Function
The Subtotal field in my Expenses tbl contains the following expression:
IIf([Expenses]="Tuition/Fees" Or "Airfare" Or "Taxi" Or "Ground Transportation" Or "Registration Fee" Or "Miscellaneous" Or "Salary for the period",[OneTimeCost],([Rate]*[Duration]))
However, it is not producing the result I need.
The result from the truepart is accurate, but nothing is resulting from the falsepart.
i.e. I do not see the calculation for [Rate]*[Duration] in the results.
Any input would be greatly appreciated.