Dear All
Please help I tried to fill in the formula on query I got an error
what mistake did i do
IIf(ABS(ROUND([Amount Refund]+[outstanding]>0,001;2;"CHECK";"")))
Thank you in advanced
Kirana
Dear All
Please help I tried to fill in the formula on query I got an error
what mistake did i do
IIf(ABS(ROUND([Amount Refund]+[outstanding]>0,001;2;"CHECK";"")))
Thank you in advanced
Kirana
Last edited by kirana2014; 04-29-2021 at 07:54 AM.
You don't say what you want this to do, but the only thing that makes sense is:
IIf(ABS(ROUND([Amount Refund]+[outstanding]))>0,001;2;"CHECK";"")
Edit: Well, that doesn't make sense either. See rorya's post below for what is almost certainly the correct answer.
Last edited by 6StringJazzer; 04-13-2021 at 08:57 AM.
Perhaps:
IIf(ABS(ROUND([Amount Refund]+[outstanding];2))>0,001;"CHECK";"")
Rory
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks