I'm in Access 2007 and I have a few fields that are currency fields. I have a report that shows these fields. When the value is something like $180.00, it only shows $180 on the report. If the value is something like $180.80, it only show $180.8 on the report. Basically, no zeroes after the decimal are shown.

Everything I try as far as setting the Format or the decimal parameters doesn't fix this. I wrote this to try to add in the zeroes on .00 values

```
="   $" & [Amount] & IIf([Amount] Like '*.*',"",".00")

```

But this doesn't work for when I only need one zero ($180.8).

Does anyone know how I can get this to just display an amount like you would normally see it? Or if not, is there a way to get around this to account for when I need one zero?