NULL value for a date field

SQL23 · #1 09-23-2002, 11:05 AM

What is the NULL value used for updating or inserting into a date field in SQL. The database is ACCESS 2000.

***sclark*** · #2 10-22-2002, 04:24 PM

First, you need to make sure that the field in the database accepts null values...you can set this in Table/Design mode. Also make sure that the field is set to Allow Zero Length. Then just enter '' for the value.

***sclark*** · #3 10-22-2002, 04:29 PM

You can also use something like this:

RS("field_name") = null