<div>
Please note, I dont know all the column names in your queries, so you will need to adjust them accordingly.
</div>


Please note, I dont know all the column names in your queries, so you will need to adjust them accordingly.

<div>
How do you do the count in Notes. &nbsp;I need to see your criteria.
</div>


How do you do the count in Notes.  I need to see your criteria.

<div>
-Sum(NoteAddedFieldDate+10<wbr />&gt;Date()) &nbsp;will count the number of occurrences where the NoteAddFieldDate is less than 10 days old.
</div>


-Sum(NoteAddedFieldDate+10>Date())  will count the number of occurrences where the NoteAddFieldDate is less than 10 days old.

<div>
<div class="content wysiwyg-content">
I have a form called &quot;FrmNotContacted&quot;. it is based on a query &quot;QryNotContacted&quot;. This form updates every 60 seconds and shows all of the new leads (imported using web response grabber) that have not been contacted and the ones that have been contacted but appointments have not been made. <br />
The first problem I have is that I need to show a column that gives me the total times we have tried to contact the client.<br />
I have a related table &quot;Notes&quot;. When I use the &quot;count&quot; function in the query &quot;QryNotContacted&quot;. &nbsp;to count the records. The problem is it no longer shows the records where the count is less than 1 (ie the new not contacted records)<br />
<br />
The second problem is that I want to count the records where the &quot;NoteAddedDate&quot; field in the &quot;notes&quot; table is less than 10 days old<br />
<br />
I am self taught with Access so please could you offer step by step instructions so I can understand the theory behind the answers.<br />

</div>
</div>


I have a form called "FrmNotContacted". it is based on a query "QryNotContacted". This form updates every 60 seconds and shows all of the new leads (imported using web response grabber) that have not been contacted and the ones that have been contacted but appointments have not been made. 
The first problem I have is that I need to show a column that gives me the total times we have tried to contact the client.
I have a related table "Notes". When I use the "count" function in the query "QryNotContacted".  to count the records. The problem is it no longer shows the records where the count is less than 1 (ie the new not contacted records)

The second problem is that I want to count the records where the "NoteAddedDate" field in the "notes" table is less than 10 days old

I am self taught with Access so please could you offer step by step instructions so I can understand the theory behind the answers.


Count in a Microsoft Access Query

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

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.