HOW CAN I ADD A "N/A TO A DATE FIELD

[Guest]

IN ACCESS CAN I USE "N/A" IN A DATE FIELD?

 

[steve]

sorry

you cant do this with microsoft access 2003.

you must upgrade to microsoft access 2004:
http://www.ammara.com/access_image_faq/access_loading_image_dialog.html


HTH

Steve

 

[Guest]

You can leave the field as a null and in your query use an IIF statement so
that if it is null then display N/A.

 

[John Vinson]

IN ACCESS CAN I USE "N/A" IN A DATE FIELD?

No. A Date is stored as a number, a precise moment of time.

You can DISPLAY N/A for NULL dates by setting the control source of a
textbox to something like

=NZ([datefield], "N/A")

but this will not be updateable.

Please ignore the spammer posting rubbish about 2004.

John W. Vinson[MVP]

 

[Jamie Collins]

No. A Date is stored as a number

Again, that a DATETIME value is stored as a number is irrelevant and
potentially counterproductive e.g. it could lead to the erroneous
assumption that a DATETIME value of 0 could be used to signify a 'N/A'
date.

Jamie.

--