Update Date with Null value

[Guest]

I have a table with a date column. There are occasions where I need to remove
the set date. I have tried using update with a Null value. This however
causes a mismatch. Is it not possible to do that and in that case would the
easiest solution be to delete the record and then isert it again without a
value for the date?

 

[Guest]

Does the field in the table allow nulls?

- Raoul

 

[Guest]

I can't find that property. I'm using Access 2003 with the Jet DB engine. The
value is not required.

 

[Guest]

I tested this

table1
Fields: a(number), dat(date)

UPDATE Table1 SET Table1.dat = Null
WHERE (((Table1.a)=1));

dat is set to not required.

- Raoul