"Not Applicable" in a date field in Access

I just had a request from a user in a database I developed. The database keeps track of dates for certain types of training. When they run the report it shows blanks where there is no date entered. If that training was not applicable to they would llike to be able to note that instead of having a blank field on the report. For example
name training 1 training2 training 2
smith 01/01/01 na 05/05/10
Any ideas?
thanks

I think what I will do is convert the field to a text. Then if they enter 01/01/1900 can have it converted to NA and still have the input mask setup with a date format.
Thanks for heading me in the right direction!!

No matter the version of Windows you are using, you may have some problems with Windows Search running too slow or possibly not running at all. Before jumping into how you can solve this issue, just know there are many other viable alternative deskt…

In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page.
The problem with sub-reports and headings:
Add a dummy group to the sub report using the expression =1:
Set the “Repeat Section” property of the dummy…