Wayne Morgan's SQL code sould work fine.
You can also build it using the Access query design grid.
In query-design mode - - -
On the menu bar, click "Query" and select "Update".
This adds a row called "Update" to the grid.
Enter "Null" into that row for the appropriate field, and
then run the query using (menu bar again) Query - Run,
or use the red "!" icon on the toolbar.
As usual, the design grid also lets you enter various types
of selection criteria, formulas, expressions, etc.
Bruce Pick
Rance R said:
Is it possible to Update a Date datatype column to Null? If so, how is it
done?
