I Need an extra pair of eyes, I just can see whats wrong with this equation. If the results = 0 then I get a #Error.

IIf(Sum(IIf([CompletionDt]<=[DateRequired],1,0))+Sum(IIf([CompletionDt]>[DateRequired],1,0))+Sum(IIf([DateRequired]>Date(),1,0))+Sum(IIf([DateRequired]<Date(),1,0))=0,0,Sum(IIf([CompletionDt]<=[DateRequired],1,0))/(Sum(IIf([CompletionDt]<=[DateRequired],1,0))+Sum(IIf([CompletionDt]>[DateRequired],1,0))+Sum(IIf([DateRequired]<Date(),1,0))))

Need to add the IF = Zero return Zero - this is on a percentage field. Maybe Divide by Zero issue.

K

Right, it only accepts two arguments, but what about:

ReturnPercent([totalCourse

JimD.