hvilken værdi har et tomt datofelt (null?)?

UPDATE table1 SET table1.dato = #12/30/2000#
WHERE (((table1.dato) Is Null));


NOTE The date is in format MM-dd-yyyy. This is the U.S date format and is necessary when working with dates

A little note: when working in queries in Denmark, you don\'t use the U.S. date format, since this will give you a wrong result. It will work fine with #12/30/2000#, since 30 can\'t be a month. But if you use #10/12/2001# instead, access will consider this december 12, 2001.

But when working in code, you usually have to use the U.S. format.

/Thomas

Correct thomas> the regional settings is responible for this when NOT working in code.
If you enter a date in query design view as #10/12/2001# then look in SQL view, you will see that its changed to #12/10/2001#  (MM-DD-YYYY). So Access is assuming that the date was enetered as per the regional settings and convering it to the U.S format for you.
By the way, England also use the same format as DK (DD-MM-YYYY).