Insert null value in column-type is date/time & format is ShortDate,in Access 2002

Hi,
I am trying to insert Null value in column(ShipDate) in my table.That
column(ShipDate)'s type id date/time and format is short date.

I am using "" to insert Null in that column(ShipDate) but it shows
warning that
customer can't append all the records in the append query.
Customer set 1 field(s) to Null due to a type conersion failure,and it
didn't add 0 record(s) to the table due to key violation, 0 record(s)
due to lock violations, and 0 record(s) due to validation rule
violations.
Do you want to run the action query anyway?

But still if I click on Yes than it will simply execute the query and
insert null value in table.
And if I click on No than it cancel the execution of query.

its caused just because i set type as date/time and put format as
short date in that column(ShipDate) in my table.

How can I remove this warning?

I am using "" to insert Null in that column(ShipDate)
What you are trying to insert is not a null but an empty string.
Use NULL instead.
If you are running an update query then in the design view of the query grid
row for Update type NULL as the data.

--
KARL DEWEY
Build a little - Test a little


" wrote:

Hi,
I am trying to insert Null value in column(ShipDate) in my table.That
column(ShipDate)'s type id date/time and format is short date.

I am using "" to insert Null in that column(ShipDate) but it shows
warning that
customer can't append all the records in the append query.
Customer set 1 field(s) to Null due to a type conersion failure,and it
didn't add 0 record(s) to the table due to key violation, 0 record(s)
due to lock violations, and 0 record(s) due to validation rule
violations.
Do you want to run the action query anyway?

But still if I click on Yes than it will simply execute the query and
insert null value in table.
And if I click on No than it cancel the execution of query.

its caused just because i set type as date/time and put format as
short date in that column(ShipDate) in my table.

How can I remove this warning?

Null and "" are not the same thing. Use Null
A date/time table field will accept Null, but not "" which is a string or
text value
--
Dave Hargis, Microsoft Access MVP


" wrote:

Hi,
I am trying to insert Null value in column(ShipDate) in my table.That
column(ShipDate)'s type id date/time and format is short date.

I am using "" to insert Null in that column(ShipDate) but it shows
warning that
customer can't append all the records in the append query.
Customer set 1 field(s) to Null due to a type conersion failure,and it
didn't add 0 record(s) to the table due to key violation, 0 record(s)
due to lock violations, and 0 record(s) due to validation rule
violations.
Do you want to run the action query anyway?

But still if I click on Yes than it will simply execute the query and
insert null value in table.
And if I click on No than it cancel the execution of query.

its caused just because i set type as date/time and put format as
short date in that column(ShipDate) in my table.

How can I remove this warning?