if statement wont return currency format

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Keith - 26 May 2005 19:09 GMT

Okay, I'm missing something. I have an if statement on a field (negative
partials), properties is set to currency on both fields(partial mrc) and
(negative partials):
Statement:
Negative Partial:
IIf([partial_mrc]<0,[partial_mrc],IIf([partial_mrc]>0,"$0.00"))

In my Negative Partial field it comes over like 83.3367 when it shoud come
across as $83.33.

Thank you for your always on-going help!

Reply to this Message

fredg - 26 May 2005 20:03 GMT

> Okay, I'm missing something. I have an if statement on a field (negative
> partials), properties is set to currency on both fields(partial mrc) and
[quoted text clipped - 7 lines]
>
> Thank you for your always on-going help!

IIf([partial_mrc]<0,Format([partial_mrc],"#.00"),IIf([partial_mrc]>0,"$0.00"))

Signature

Fred
Please only reply to this newsgroup.
I do not reply to personal email.

Reply to this Message