<div>
<div class="content wysiwyg-content">
What is wrong with this code?<br />
<br />
me.txt10EnvInventory = Nz(DSum(&quot;Qty&quot;, &quot;tblEnvelopeInventory&quot;, &quot;[CompanyName] = '&quot; &amp;&nbsp;me.txtBankName &amp;&nbsp;&quot;' And [EnvelopeStyle] = '&quot; &amp;&nbsp;Me.txt10WindEp &quot;'),0)<br />
<br />
The apostrophies and double quote marks mess me up every time.<br />
<br />
--Steve
</div>
</div>


What is wrong with this code?

me.txt10EnvInventory = Nz(DSum("Qty", "tblEnvelopeInventory", "[CompanyName] = '" & me.txtBankName & "' And [EnvelopeStyle] = '" & Me.txt10WindEp "'),0)

The apostrophies and double quote marks mess me up every time.

--Steve

Another DSum syntax question

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.