<div>
is this a text field?<br />
<br />
If it is a date, you can change the display format of the date, but not the actual data itself. &nbsp;Or you could create a query based on that table that displays the date field in that format using the format function:<br />
<br />
MonYr: Format([DateField], &quot;mm/yyyy&quot;)
</div>


is this a text field?

If it is a date, you can change the display format of the date, but not the actual data itself.  Or you could create a query based on that table that displays the date field in that format using the format function:

MonYr: Format([DateField], "mm/yyyy")

<div>
do I put that in a query or can I change the table values themselves?
</div>


do I put that in a query or can I change the table values themselves?

<div>
BTW, when I said you can change the display format, I meant in the table design view. &nbsp;If you set the Format property on the General Tab of the Field Properties in table design view, the data will be displayed as mm/yyyy, but when you put your cursor in the field, it will display as the actual data.
</div>


BTW, when I said you can change the display format, I meant in the table design view.  If you set the Format property on the General Tab of the Field Properties in table design view, the data will be displayed as mm/yyyy, but when you put your cursor in the field, it will display as the actual data.

<div>
<div class="content wysiwyg-content">
I have a field in a table where the date is stored as mm/dd/yyyy, i would like to convert the date in those fields to &nbsp; mm/yyyyy.<br />
<br />
<br />
How can I do this?
</div>
</div>


I have a field in a table where the date is stored as mm/dd/yyyy, i would like to convert the date in those fields to   mm/yyyyy.


How can I do this?

Convert Date value in Access

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.