Updating Date field to Null

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

Guest

Is it possible to Update a Date datatype column to Null? If so, how is it done?
 
UPDATE Table1 SET Table1.Field1 = Null;

Where Table1 is the name of your table and Field1 is the name of your date
field.

--
Wayne Morgan
MS Access MVP


Rance R said:
Is it possible to Update a Date datatype column to Null? If so, how is it
Click to expand...
done?
 
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
Click to expand...
done?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

#error - Blank 3
counting Null fields 3
Null Date Question 1
Update date field to Is Null in an update query 3
Using Is Null in Update query 3
Update query should not fire if prompt is null 1
No dates in 1st 5 records of excel spreadsheet 4
Update Query based on leaving date 1

Back
Top