Iff statement will not allow me to set format...

[LanieB]

Average: IIf([Points Earned]=0 AND [Points Available]=0,"N/A",IIf([Points Available]=0,0,[Points Earned]/[Points Available])
I am using the IFF statement above and before I added this section of it (IIf([Points Earned]=0 AND [Points Available]=0,"N/A",) I had the result showing as a percentage with two decimal places. Now I am unable to display the results as a percentage OR pick the amount of decimal places. I have tried to set the format and change the amount of decimals in both the query and the report, but neither will work. Does anyone know how I can get my result to display as percentages?

[pdebaets]

try this:

Average: IIf([Points Earned]=0 AND [Points Available]=0,"N/A",format(IIf([Points Available]=0,0,[Points Earned]/[Points Available]),"percent"))

[LanieB]

I change the "N/A" to NULL, that way it just shows up blank AND it will allow me to format!!