<div>
Perfect!!! &nbsp;Thank you. &nbsp;I keep stumbling over these syntax issues.
</div>


Perfect!!!  Thank you.  I keep stumbling over these syntax issues.

<div>
Try..<br />
<br />

<pre><code id="code-20-41897718-1">DCount(&quot;[ExpiredID]&quot;,&quot;tblExpiredListings&quot;,&quot;DiffAgentDateRelisted BETWEEN #&quot; &amp; [Forms]![frmExpiredListingReportDateRange]![txtStartDate] &amp; &quot;# AND #&quot; &amp; [Forms]![frmExpiredListingReportDateRange]![txtEndDate] &amp; &quot;#&quot; &amp; &quot; AND Reason is not null&quot;)</code></pre>
</div>


Try..



DCount("[ExpiredID]","tblExpiredListings","DiffAgentDateRelisted BETWEEN #" & [Forms]![frmExpiredListingReportDateRange]![txtStartDate] & "# AND #" & [Forms]![frmExpiredListingReportDateRange]![txtEndDate] & "#" & " AND Reason is not null")

<div>
you're welcome ~ happy to help
</div>


<div>
<div class="content wysiwyg-content">
What is wrong with this syunatx?<br />
<br />
=DCount(&quot;[ExpiredID]&quot;,&quot;tbl<wbr />ExpiredLis<wbr />tings&quot;,&quot;Di<wbr />ffAgentDat<wbr />eRelisted BETWEEN #&quot; &amp;&nbsp;[Forms]![frmExpiredListing<wbr />ReportDate<wbr />Range]![tx<wbr />tStartDate<wbr />] &amp;&nbsp;&quot;# AND #&quot; &amp;&nbsp;[Forms]![frmExpiredListing<wbr />ReportDate<wbr />Range]![tx<wbr />tEndDate] &amp;&nbsp;&quot;#&quot; &amp;&nbsp;&quot; AND Reason is not null&quot;))
</div>
</div>


What is wrong with this syunatx?

=DCount("[ExpiredID]","tblExpiredListings","DiffAgentDateRelisted BETWEEN #" & [Forms]![frmExpiredListingReportDateRange]![txtStartDate] & "# AND #" & [Forms]![frmExpiredListingReportDateRange]![txtEndDate] & "#" & " AND Reason is not null"))

Another multiple criteria puzzle

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.