Software

Ask something
Discussion Locked

Access Update of date field

0 helpful
5 replies

by symesd

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I want to replace a date with a blank.
It won't allow me to set it to null.
What can I do?

5 replies

by bristar

You need to be more specific as to your problem:
* What version of access?
* In a table, query, module or form?
* If in a module, display the corresponding code.
* If in query or form, display referencing fields
* How are you trying to set it?
Be as specific as you can on the situation. It works fine for me, so I need to know what is happening for you.

by symesd

Right. I have a C-ISAM database that uses a Transoft ODBC driver to allow updates from Access 2000 or 2002 queries (neither ver works for what I'm trying to do). It is a simple update query on a Date field with the following syntax:

UPDATE dbo_table SET dbo_table.DateField = Null
WHERE (((dbo_table.DateField)=#1/1/1900#));

I want to replace all dates of 01/01/1900 with a blank.

by ccjonathan

Instead of using the word Null, try two quotation marks.

UPDATE dbo_table SET dbo_table.DateField = ""
WHERE (((dbo_table.DateField)=#1/1/1900#));

This discussion is closed to new replies.