For some reason, I have been unable to format a number to a percentage in either the form or query properties. I found this format formula on another site, however I only want 0 decimals i.e. 50% not 50.00%
Is there a way to use the formula and get 0 decimals??
PctWTMD: Format(IIf([WTMD_Totals]=0,"-",[WTMD_PMI_Complete]/[WTMD_Totals]),"Percent")