Formatting a Calculated IIf Field on Report (1 Viewer)

Hi all,

I'm wondering if you can help me with something that is driving me mad. I have some calculated IIf fields on a report that won't format as currency to 2 decimal places. They are stored in the source table as currency to 2 decimal places, and formatted as currency to 2 decimal places using the properties of the fields in the query.

When I then set the properties as currency to 2 decimal places in the report they show as a number with no decimal place rounding on the report that is exported. Why is this happening I just cannot understand it?

Below here is an example of one of the calculated fields, if maybe there is something I can do to tweak this to make it work it would be very much appreciated;


Essentially here the field should display 0.25% of the [Quarter£] field for that group if either of these statements show in the [Red Flag] field.

Any help from you guys would be much appreciated.

Thanks

Try the format function:

Easy when you know how, that's worked perfectly, thank you so much.