<div>
Try something like this. &nbsp;Post it in the SQL view, and update as needed with actual table/column names:<br />
<br />
<br />

<pre><code id="code-20-35343885-1">SELECT Count([app date]) AS Records
FROM [tblMain]
WHERE [app date] &lt;= DateAdd(&quot;m&quot;, -1, Date())</code></pre>
</div>


Try something like this.  Post it in the SQL view, and update as needed with actual table/column names:




SELECT Count([app date]) AS Records
FROM [tblMain]
WHERE [app date] <= DateAdd("m", -1, Date())

<div>
As a DCount:<br />
<br />
<br />
<br />
DCount(&quot;[app date]&quot;, &quot;[tblMain]&quot;, &quot;[app date] &lt;= #&quot; &amp;&nbsp;Date() &amp;&nbsp;&quot;#&quot;)
</div>


As a DCount:



DCount("[app date]", "[tblMain]", "[app date] <= #" & Date() & "#")

<div>
Patrick: &nbsp;Your DCount doesn't cut it.
</div>


<div>
Now you've covered the bases.
</div>


<div>
<div class="content wysiwyg-content">
First of all I am still a novice with Microsoft Access VBA and queries.<br />
<br />
I am trying to work out how I can count records in a MS Access 2010 table, based on comparing a date field with today's date in an Event Procedure within a form.<br />
<br />
Basically I have the field &quot;app date&quot; in a table called &quot;tblMain&quot;and I want to count the number of records in which the &quot;app date&quot; was more than 1 calendar month ago. I am assuming this uses a DCount statement but I'm not sure how to implement this.<br />
<br />
Any help would be greatly appreciated.
</div>
</div>


First of all I am still a novice with Microsoft Access VBA and queries.

I am trying to work out how I can count records in a MS Access 2010 table, based on comparing a date field with today's date in an Event Procedure within a form.

Basically I have the field "app date" in a table called "tblMain"and I want to count the number of records in which the "app date" was more than 1 calendar month ago. I am assuming this uses a DCount statement but I'm not sure how to implement this.

Any help would be greatly appreciated.

Microsoft Access VBA - count records with date comparisons

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.

Microsoft Access

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.