I have a field in a query that is giving me #error. The two fields it is using (SumOfSumOfEXT_COST, and SumOfSumOfACT_HOURS) are both calculating to have a value of 0.
Does Access spit out an error when it does 0 divided by 0? How do I turn that error into a 0?Code:HR_RATE: NZ([SumOfSumOfEXT_COST],0)/NZ([SumOfSumOfACT_HOURS],0)