Update Date with Null value

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
I can't find that property. I'm using Access 2003 with the Jet DB engine. The
value is not required.
 
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
 
Back
Top