<div>
The point is that you cannot divide by zero so using Nz(), although it will change null to zero isn't a complete solution. &nbsp;Rey's example shows how to return a 0 when the divisor is zero
</div>


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

<div>
<div class="content wysiwyg-content">
I'm getting #Div/0! in a query field result using:<br />
<br />
SchedLBHR: [tblLoadingSchedule.TotalW<wbr />eight]/[Co<wbr />nvertedSch<wbr />edHrs]<br />
<br />
I tried:<br />
<br />
SchedLBHR: [tblLoadingSchedule.TotalW<wbr />eight]/Nz(<wbr />[Converted<wbr />SchedHrs],<wbr />0)<br />
<br />
But that didn't work.
</div>
</div>


I'm getting #Div/0! in a query field result using:

SchedLBHR: [tblLoadingSchedule.TotalWeight]/[ConvertedSchedHrs]

I tried:

SchedLBHR: [tblLoadingSchedule.TotalWeight]/Nz([ConvertedSchedHrs],0)

But that didn't work.

#Div/0! in query field

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.