Formatting a Calculated IIf Field on Report

[MJ_Wilkinson]

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;

M03: IIf([Red Flag]="Fail Qtr" Or [Red Flag]="Appeal Pending" Or [Red Flag]="Appeal Rejected",[Quarter£]*0.0025,0)

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

 

[Eljefegeneo]

Try the format function:

 Format([[FONT=&quot]Quarter£]*[/FONT]*.0025, "Currency"), 0)

 

[MJ_Wilkinson]

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