SteveL13
asked on
#Div/0! in query field
I'm getting #Div/0! in a query field result using:
SchedLBHR: [tblLoadingSchedule.TotalW eight]/[Co nvertedSch edHrs]
I tried:
SchedLBHR: [tblLoadingSchedule.TotalW eight]/Nz( [Converted SchedHrs], 0)
But that didn't work.
SchedLBHR: [tblLoadingSchedule.TotalW
I tried:
SchedLBHR: [tblLoadingSchedule.TotalW
But that didn't work.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
The point is that you cannot divide by zero so using Nz(), although it will change null to zero isn't a complete solution. Rey's example shows how to return a 0 when the divisor is zero
ASKER
That did it. Thanks.