Isn't the IIF statement a joy.
I have three IIF statements that all work fine on their own in my query field.
they are as follows.
IIf([unit_amt]=1,[split1])
IIf([unit_amt]=2,[split2])
IIf([unit_amt]=3,[split3])
independantly they populate the correct data. How do I join them all together in the same column in my query so I don't have to have 3 columns and they display the correct info. I can't seem to make it work right. Comma here, parenthese there, quote over yonder.............STUMPED!