<div>
dejandejanovic,<br />
<br />
I am rather surprised by your choice of grade; a 'C' grade is typically reserved for cases where the answer was vague, and the Expert never replied to reasonable requests for clarification.<br />
<br />
If something was missing from my answer, you could have posted a follow-up comment asking for more information, and I would have tried to help you.<br />
<br />
If you really felt that my answer was that bad, I would have preferred that you deleted the question.<br />
<br />
Patrick
</div>


dejandejanovic,

I am rather surprised by your choice of grade; a 'C' grade is typically reserved for cases where the answer was vague, and the Expert never replied to reasonable requests for clarification.

If something was missing from my answer, you could have posted a follow-up comment asking for more information, and I would have tried to help you.

If you really felt that my answer was that bad, I would have preferred that you deleted the question.

Patrick

<div>
No, no it was not bad. It was cool tip. I give all the A, but sometimes happened by mistake I click B, or C. I will delete message, just to find how to do it.. Sorry, again.
</div>


No, no it was not bad. It was cool tip. I give all the A, but sometimes happened by mistake I click B, or C. I will delete message, just to find how to do it.. Sorry, again.

<div>
No worries, it looks like the Mods got around to it.<br />
<br />
:)<br />
<br />
Patrick
</div>


No worries, it looks like the Mods got around to it.

:)

Patrick

<div>
Yes, I have send Request Attention :-)
</div>


<div>
<div class="content wysiwyg-content">
Hello, <br />
I`m using MSAccess for .net application. Application is storing date records as 13.3.2011 7:06:13.<br />
<br />
How can write a query as like this? <br />

<pre><code id="code-10-26883591-1">Between #Date() hh:nn:ss# and #Date() hh:nn:ss#</code></pre>
<br />
Thank you in advance for help to anyone.
</div>
</div>


Hello, 
I`m using MSAccess for .net application. Application is storing date records as 13.3.2011 7:06:13.

How can write a query as like this? 
(CODE)

Thank you in advance for help to anyone.

How to get values Between #Date() hh:nn:ss# and #Date() hh:nn:ss# ?

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.