<div>
Although if you are doing this for many records, the DSUM() could make this a long running query. &nbsp;You might be better off with some form of aggregate query based grouped on a specific field (either as a stand-alone or sub query) and then joining that query to this one.
</div>


<div>
<div class="content wysiwyg-content">
In query designer for an expression, what is wrong with this syntax?<br />
<br />
TotQtyInsAndOuts: Nz(DSum(&quot;[QTY_ORDERED]&quot;,&quot;t<wbr />blInventor<wbr />y&quot;, [TRNX_TYPE] in ('I','O')&quot;),0)<br />
<br />
--Steve
</div>
</div>


In query designer for an expression, what is wrong with this syntax?

TotQtyInsAndOuts: Nz(DSum("[QTY_ORDERED]","tblInventory", [TRNX_TYPE] in ('I','O')"),0)

--Steve

Syntax Problem

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.