<div>
select [datefield]<br />
from tablex<br />
where &nbsp;[datefield] Between Dateadd(&quot;yyyy&quot;,-6,[Enter Date]) And [Enter Date]
</div>


select [datefield]
from tablex
where  [datefield] Between Dateadd("yyyy",-6,[Enter Date]) And [Enter Date]

<div>
Sorry, I just realized that I posted the query wrong.<br />
<br />
ex: user input - 01/01/2015<br />
<br />
&nbsp;the query would pull only the dates that are in the 6th year, which would be all of 2009
</div>


Sorry, I just realized that I posted the query wrong.

ex: user input - 01/01/2015

 the query would pull only the dates that are in the 6th year, which would be all of 2009

<div>
Sorry, I had it wrong again.<br />
<br />
I posted another question.<br />
<br />
<a href="https://www.experts-exchange.com/questions/28515939/Access-2007-Date-Query-Criteria-6-by-date.html" rel="ugc">https://www.experts-exchange.com/questions/28515939/Access-2007-Date-Query-Criteria-6-by-date.html</a>
</div>


Sorry, I had it wrong again.

I posted another question.

https://www.experts-exchange.com/questions/28515939/Access-2007-Date-Query-Criteria-6-by-date.html [https://www.experts-exchange.com/questions/28515939/Access-2007-Date-Query-Criteria-6-by-date.html]

<div>
<div class="content wysiwyg-content">
I need help with a query on one of my tables. On one of the table fields there is a date mm/dd/yyyy. I need to have the user input a future date and then count back 6 years from the table field date. I only want to see the dates that fall in the 6 year window.<br />
<br />
ex: user input - 01/01/2015<br />
<br />
the query would pull only the dates starting 01/01/2009 to 01/01/2015
</div>
</div>


I need help with a query on one of my tables. On one of the table fields there is a date mm/dd/yyyy. I need to have the user input a future date and then count back 6 years from the table field date. I only want to see the dates that fall in the 6 year window.

ex: user input - 01/01/2015

the query would pull only the dates starting 01/01/2009 to 01/01/2015

Access 2007 Date Query Criteria -6

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.