MS Access Format for a query

Hello,

Thanks in advance for helping!!

I need to know how to add a format to a IIF query:

I know how to do it for a simply IIF: Expr:Format(IIF([Query]=0,"x","0.00")

But how do i add a format to a query that has about 5 IIF statements in it. I cant get it format each if statement.

Code: IIf([type]="A"," ",
IIf([type]="B",([correct rate]-[Overall])/100,
IIf([TYPE]="C",([correct rate]-[Income])/100,
IIf([TYPE]="D",([correct rate]-[Income])/100,([correct rate]-[Current Rate])/100))))

I need to know how i can make it so that the above is in the same format for each iif statement.

Thanks

PM


MS Access 2003