<div>
try this<br />
<br />
<br />
Demand: Sum(Nz([Qty],0)-Nz([qryPar<wbr />tNPrintOrd<wbr />QtysAM.Sum<wbr />OfQty],0-N<wbr />z([qryPart<wbr />NSalesOrdQ<wbr />tysAM.SumO<wbr />fQty],0)<br />
<br />
<br />
remove the last &quot;)&quot; from Sum(Nz([Qty],0))
</div>


try this


Demand: Sum(Nz([Qty],0)-Nz([qryPartNPrintOrdQtysAM.SumOfQty],0-Nz([qryPartNSalesOrdQtysAM.SumOfQty],0)


remove the last ")" from Sum(Nz([Qty],0))

<div>
<div class="content wysiwyg-content">
Can someone spot the syntax error here:<br />
<br />
Demand: Sum(Nz([Qty],0))-Nz([qryPa<wbr />rtNPrintOr<wbr />dQtysAM.Su<wbr />mOfQty],0-<wbr />Nz([qryPar<wbr />tNSalesOrd<wbr />QtysAM.Sum<wbr />OfQty],0)<br />
<br />
--Steve
</div>
</div>


Can someone spot the syntax error here:

Demand: Sum(Nz([Qty],0))-Nz([qryPartNPrintOrdQtysAM.SumOfQty],0-Nz([qryPartNSalesOrdQtysAM.SumOfQty],0)

--Steve

Problem with syntax on calculated field in a query

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.