Format iiif calculation result...

[denileigh]

Hello all,

I have a report with and iif then calculation in it. ie: iif([Text32-Text31]>0, 5.00)

I need the result to be formatted like this 00000.00 so that it would return a number like this 00005.00. How do I put that formatting in the iif formula??

Thanks,
Dianne

 

[NickHa]

if you put your expression within a Format statement, it will return the text you want:
Format(iif([Text32-Text31]>0, 5.00),"00000.00")
What happened to the false part of the iif statement?

 

[denileigh]

It's there...statement works fine...just didn't type it all out. Thanks for the format part! Will try it!!