<div>
<div class="content wysiwyg-content">
Someone helped me yesterday with part of this but I have to add to it. &nbsp;What is wrong with this syntax?<br />
<br />
&nbsp; &nbsp; &nbsp;Me.txtBooked = DSum(&quot;[QuotedSales]&quot;, &quot;OpenJob&quot;, &quot;[ProductCode] &lt;&gt;&nbsp;350 and [BookedDate] between &quot;&nbsp;&amp; &quot;#&quot; &amp;&nbsp;Forms!frmSelectDateRange!t<wbr />xtStart &amp;&nbsp;&quot;#&quot; &amp;&nbsp;&quot; And &quot;&nbsp;&amp; &quot;#&quot; &amp;&nbsp;Forms!frmSelectDateRange!t<wbr />xtEnd &amp;&nbsp;&quot;#&quot; &amp;&nbsp;&quot;&quot; and [DueDate] between &quot;&nbsp;&amp; &quot;#&quot; &amp;&nbsp;Forms!frmSelectDateRange!t<wbr />xtCMS &amp;&nbsp;&quot;#&quot; &amp;&nbsp;&quot; And &quot;&nbsp;&amp; &quot;#&quot; &amp;&nbsp;Forms!frmSelectDateRange!t<wbr />xtCME &amp;&nbsp;&quot;#&quot; &amp;&nbsp;&quot;&quot;)<br />
<br />
--Steve<br />

</div>
</div>


Someone helped me yesterday with part of this but I have to add to it.  What is wrong with this syntax?

     Me.txtBooked = DSum("[QuotedSales]", "OpenJob", "[ProductCode] <> 350 and [BookedDate] between " & "#" & Forms!frmSelectDateRange!txtStart & "#" & " And " & "#" & Forms!frmSelectDateRange!txtEnd & "#" & "" and [DueDate] between " & "#" & Forms!frmSelectDateRange!txtCMS & "#" & " And " & "#" & Forms!frmSelectDateRange!txtCME & "#" & "")

--Steve


DSum question again

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.