<div>
Unless you store the date as a text field you can't put text in it. &nbsp;The way I would do it is put in a date like 1/1/1950 for N/A and then when you write your query do an <br />
<br />
iif(MyDateField= #1/1/1950#, &quot;N/A&quot;, MyDateField)
</div>


Unless you store the date as a text field you can't put text in it.  The way I would do it is put in a date like 1/1/1950 for N/A and then when you write your query do an

iif(MyDateField= #1/1/1950#, "N/A", MyDateField)

<div>
<div class="content wysiwyg-content">
Is it possible to use Date, blank and &quot;N/A&quot; as acceptable entries in a field? &nbsp;<br />
<br />
I'll need to later be able to sort by date (which is why I don't want to use text field). &nbsp;help.<br />
<br />
thanks<br />
<br />

</div>
</div>


Is it possible to use Date, blank and "N/A" as acceptable entries in a field?  

I'll need to later be able to sort by date (which is why I don't want to use text field).  help.

thanks



Date, blank and &quot;N/A&quot; as acceptable entries

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.

Date, blank and &quot;N/A&quot; as acceptable entries

Date, blank and "N/A" as acceptable entries