#error in my IIF statement (currency issue)



I've had too much to drink tonight and my wife doesnt want to have sex
with me :(
but it's broken my concentration and I cant get my IIF statement to
work. I'm tyring to setup an iif where iff the AMOUNTPAID colunm
equals a certain number, then the expression returns "A Positive
REsult","or a negative result" and it gives me the #error, here we go:


returns #error

The amountPAID column is a currency column what "strings" do I use?
Thanks to anyone in advance.


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question