conditional formatting of currency field?

  • Thread starter Thread starter Jen
  • Start date Start date
J

Jen

Hi there,

I'm trying to produce a salary list that includes
both "$xx,xxx" and "$x.xx per hour" formats. Our table
contains just the numerical values, and the field is set
as currency. Is there an easy way to produce the mixed-
format list we want, or do we have to convert the field to
text and add in all the $ signs? If so, will the "auto"
setting take care of the changing decimal needs (none for
salaries, 2 for wages)?

Thanks
jen
 
Jen:

Use the Format function as in:

=Format (MyCurrencyField, "$#,###")

and

=Format (MySecondCurField, "$#,###.00)
 
If i'm reading this right, this requires the different
numbers to be in two different fields, right? All of our
numbers are in the same field; we want to set anything
from 0-999 to read as $#.##, and anything >1000 to read as
$#,###. Is that possible?

thanks
jen
 
Jen:

I suppose you can add an iif statement wrapper as in:

= IIF(MyCurrencyField <1000, Format (MyCurrencyField, "$#,###.00),Format
(MyCurrencyField, "$#,###))
 
Back
Top