Recent content by TheHunter

Last try hopefully: =IIf([Motions - No of Hours Estimated:])=0,Null,[Motions - Actual Hours Incurred:]- [Motions - No of Hours Estimated:])/[Motions - No of Hours Estimated:] The actual names of the three fields are: Motions - No of Hours Estimated: Motions - Actual Hours Incurred: Motions %...

Oh my goodness. Now I get #Name? in the % over under field on all of the forms/records. :banghead:

I know I'm being a baby about this, but I've been working on this all day and trying to resolve it myself. The names of three fields are: Actual Hours Incurred, Hours Estimated, and % over/under. Can you please give me the full expression that I need to use.

:banghead: In my table, I have two fields that are sometimes going to be zero (both fields zero at the same time). When the field that contains a formula that includes one of the fields that contain the zero processes the operation, it returns the #Num! For example, Number of Hours Estimated...