<div>
format(now(),&quot;Mmmm yyyy&quot;)
</div>


<div>
i gave him what he wanted. &nbsp;So why did he accept your answer? &nbsp;
</div>


i gave him what he wanted.  So why did he accept your answer?  

<div>
I had an existing field named adate which I needed to extract from, now() will not work
</div>


I had an existing field named adate which I needed to extract from, now() will not work

<div>
so then you should have been more clear in your question then
</div>


so then you should have been more clear in your question then

<div>
&quot;Date/Time Field ...&quot;<br />
<br />
That was very clear to me. &nbsp;<br />
<br />
Also, when I brought up the Q ... no one had yet posted. &nbsp;I got a phone call, and came back to it, typed my answer ... and hit Submit.<br />
<br />
Sorry ....<br />
<br />
mx
</div>


"Date/Time Field ..."

That was very clear to me.  

Also, when I brought up the Q ... no one had yet posted.  I got a phone call, and came back to it, typed my answer ... and hit Submit.

Sorry ....

mx

<div>
sorry, will make sure to be clear next time.
</div>


sorry, will make sure to be clear next time.

<div>
<div class="content wysiwyg-content">
Microsoft Access<br />
Date/Time Field - &nbsp;Monday, April 02, 2007- ....extract month and year to show &quot;April 2007&quot;
</div>
</div>


Microsoft Access
Date/Time Field -  Monday, April 02, 2007- ....extract month and year to show "April 2007"

extract month and year from date/time field

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.